package com.desksoft.ecommerce.entity.logistics.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class DemanddExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public DemanddExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andBillnoIsNull() {
            addCriterion("BillNo is null");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNotNull() {
            addCriterion("BillNo is not null");
            return (Criteria) this;
        }

        public Criteria andBillnoEqualTo(String value) {
            addCriterion("BillNo =", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotEqualTo(String value) {
            addCriterion("BillNo <>", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThan(String value) {
            addCriterion("BillNo >", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThanOrEqualTo(String value) {
            addCriterion("BillNo >=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThan(String value) {
            addCriterion("BillNo <", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThanOrEqualTo(String value) {
            addCriterion("BillNo <=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLike(String value) {
            addCriterion("BillNo like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotLike(String value) {
            addCriterion("BillNo not like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoIn(List<String> values) {
            addCriterion("BillNo in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotIn(List<String> values) {
            addCriterion("BillNo not in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoBetween(String value1, String value2) {
            addCriterion("BillNo between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotBetween(String value1, String value2) {
            addCriterion("BillNo not between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andDccodeIsNull() {
            addCriterion("DCCode is null");
            return (Criteria) this;
        }

        public Criteria andDccodeIsNotNull() {
            addCriterion("DCCode is not null");
            return (Criteria) this;
        }

        public Criteria andDccodeEqualTo(String value) {
            addCriterion("DCCode =", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotEqualTo(String value) {
            addCriterion("DCCode <>", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeGreaterThan(String value) {
            addCriterion("DCCode >", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeGreaterThanOrEqualTo(String value) {
            addCriterion("DCCode >=", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLessThan(String value) {
            addCriterion("DCCode <", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLessThanOrEqualTo(String value) {
            addCriterion("DCCode <=", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLike(String value) {
            addCriterion("DCCode like", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotLike(String value) {
            addCriterion("DCCode not like", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeIn(List<String> values) {
            addCriterion("DCCode in", values, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotIn(List<String> values) {
            addCriterion("DCCode not in", values, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeBetween(String value1, String value2) {
            addCriterion("DCCode between", value1, value2, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotBetween(String value1, String value2) {
            addCriterion("DCCode not between", value1, value2, "dccode");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNull() {
            addCriterion("ItemCode is null");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNotNull() {
            addCriterion("ItemCode is not null");
            return (Criteria) this;
        }

        public Criteria andItemcodeEqualTo(String value) {
            addCriterion("ItemCode =", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotEqualTo(String value) {
            addCriterion("ItemCode <>", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThan(String value) {
            addCriterion("ItemCode >", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ItemCode >=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThan(String value) {
            addCriterion("ItemCode <", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThanOrEqualTo(String value) {
            addCriterion("ItemCode <=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLike(String value) {
            addCriterion("ItemCode like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotLike(String value) {
            addCriterion("ItemCode not like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeIn(List<String> values) {
            addCriterion("ItemCode in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotIn(List<String> values) {
            addCriterion("ItemCode not in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeBetween(String value1, String value2) {
            addCriterion("ItemCode between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotBetween(String value1, String value2) {
            addCriterion("ItemCode not between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andDeptcodeIsNull() {
            addCriterion("DeptCode is null");
            return (Criteria) this;
        }

        public Criteria andDeptcodeIsNotNull() {
            addCriterion("DeptCode is not null");
            return (Criteria) this;
        }

        public Criteria andDeptcodeEqualTo(String value) {
            addCriterion("DeptCode =", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotEqualTo(String value) {
            addCriterion("DeptCode <>", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeGreaterThan(String value) {
            addCriterion("DeptCode >", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeGreaterThanOrEqualTo(String value) {
            addCriterion("DeptCode >=", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeLessThan(String value) {
            addCriterion("DeptCode <", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeLessThanOrEqualTo(String value) {
            addCriterion("DeptCode <=", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeLike(String value) {
            addCriterion("DeptCode like", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotLike(String value) {
            addCriterion("DeptCode not like", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeIn(List<String> values) {
            addCriterion("DeptCode in", values, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotIn(List<String> values) {
            addCriterion("DeptCode not in", values, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeBetween(String value1, String value2) {
            addCriterion("DeptCode between", value1, value2, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotBetween(String value1, String value2) {
            addCriterion("DeptCode not between", value1, value2, "deptcode");
            return (Criteria) this;
        }

        public Criteria andSeqnoIsNull() {
            addCriterion("SeqNo is null");
            return (Criteria) this;
        }

        public Criteria andSeqnoIsNotNull() {
            addCriterion("SeqNo is not null");
            return (Criteria) this;
        }

        public Criteria andSeqnoEqualTo(Integer value) {
            addCriterion("SeqNo =", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoNotEqualTo(Integer value) {
            addCriterion("SeqNo <>", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoGreaterThan(Integer value) {
            addCriterion("SeqNo >", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoGreaterThanOrEqualTo(Integer value) {
            addCriterion("SeqNo >=", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoLessThan(Integer value) {
            addCriterion("SeqNo <", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoLessThanOrEqualTo(Integer value) {
            addCriterion("SeqNo <=", value, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoIn(List<Integer> values) {
            addCriterion("SeqNo in", values, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoNotIn(List<Integer> values) {
            addCriterion("SeqNo not in", values, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoBetween(Integer value1, Integer value2) {
            addCriterion("SeqNo between", value1, value2, "seqno");
            return (Criteria) this;
        }

        public Criteria andSeqnoNotBetween(Integer value1, Integer value2) {
            addCriterion("SeqNo not between", value1, value2, "seqno");
            return (Criteria) this;
        }

        public Criteria andPacksizeIsNull() {
            addCriterion("PackSize is null");
            return (Criteria) this;
        }

        public Criteria andPacksizeIsNotNull() {
            addCriterion("PackSize is not null");
            return (Criteria) this;
        }

        public Criteria andPacksizeEqualTo(BigDecimal value) {
            addCriterion("PackSize =", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeNotEqualTo(BigDecimal value) {
            addCriterion("PackSize <>", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeGreaterThan(BigDecimal value) {
            addCriterion("PackSize >", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PackSize >=", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeLessThan(BigDecimal value) {
            addCriterion("PackSize <", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PackSize <=", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeIn(List<BigDecimal> values) {
            addCriterion("PackSize in", values, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeNotIn(List<BigDecimal> values) {
            addCriterion("PackSize not in", values, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PackSize between", value1, value2, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PackSize not between", value1, value2, "packsize");
            return (Criteria) this;
        }

        public Criteria andPackunitIsNull() {
            addCriterion("PackUnit is null");
            return (Criteria) this;
        }

        public Criteria andPackunitIsNotNull() {
            addCriterion("PackUnit is not null");
            return (Criteria) this;
        }

        public Criteria andPackunitEqualTo(String value) {
            addCriterion("PackUnit =", value, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitNotEqualTo(String value) {
            addCriterion("PackUnit <>", value, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitGreaterThan(String value) {
            addCriterion("PackUnit >", value, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitGreaterThanOrEqualTo(String value) {
            addCriterion("PackUnit >=", value, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitLessThan(String value) {
            addCriterion("PackUnit <", value, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitLessThanOrEqualTo(String value) {
            addCriterion("PackUnit <=", value, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitLike(String value) {
            addCriterion("PackUnit like", value, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitNotLike(String value) {
            addCriterion("PackUnit not like", value, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitIn(List<String> values) {
            addCriterion("PackUnit in", values, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitNotIn(List<String> values) {
            addCriterion("PackUnit not in", values, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitBetween(String value1, String value2) {
            addCriterion("PackUnit between", value1, value2, "packunit");
            return (Criteria) this;
        }

        public Criteria andPackunitNotBetween(String value1, String value2) {
            addCriterion("PackUnit not between", value1, value2, "packunit");
            return (Criteria) this;
        }

        public Criteria andUnitIsNull() {
            addCriterion("Unit is null");
            return (Criteria) this;
        }

        public Criteria andUnitIsNotNull() {
            addCriterion("Unit is not null");
            return (Criteria) this;
        }

        public Criteria andUnitEqualTo(String value) {
            addCriterion("Unit =", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotEqualTo(String value) {
            addCriterion("Unit <>", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThan(String value) {
            addCriterion("Unit >", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThanOrEqualTo(String value) {
            addCriterion("Unit >=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThan(String value) {
            addCriterion("Unit <", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThanOrEqualTo(String value) {
            addCriterion("Unit <=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLike(String value) {
            addCriterion("Unit like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotLike(String value) {
            addCriterion("Unit not like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitIn(List<String> values) {
            addCriterion("Unit in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotIn(List<String> values) {
            addCriterion("Unit not in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitBetween(String value1, String value2) {
            addCriterion("Unit between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotBetween(String value1, String value2) {
            addCriterion("Unit not between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andTaxrateIsNull() {
            addCriterion("TaxRate is null");
            return (Criteria) this;
        }

        public Criteria andTaxrateIsNotNull() {
            addCriterion("TaxRate is not null");
            return (Criteria) this;
        }

        public Criteria andTaxrateEqualTo(BigDecimal value) {
            addCriterion("TaxRate =", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateNotEqualTo(BigDecimal value) {
            addCriterion("TaxRate <>", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateGreaterThan(BigDecimal value) {
            addCriterion("TaxRate >", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TaxRate >=", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateLessThan(BigDecimal value) {
            addCriterion("TaxRate <", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TaxRate <=", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateIn(List<BigDecimal> values) {
            addCriterion("TaxRate in", values, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateNotIn(List<BigDecimal> values) {
            addCriterion("TaxRate not in", values, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TaxRate between", value1, value2, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TaxRate not between", value1, value2, "taxrate");
            return (Criteria) this;
        }

        public Criteria andPcsIsNull() {
            addCriterion("Pcs is null");
            return (Criteria) this;
        }

        public Criteria andPcsIsNotNull() {
            addCriterion("Pcs is not null");
            return (Criteria) this;
        }

        public Criteria andPcsEqualTo(Integer value) {
            addCriterion("Pcs =", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsNotEqualTo(Integer value) {
            addCriterion("Pcs <>", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsGreaterThan(Integer value) {
            addCriterion("Pcs >", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsGreaterThanOrEqualTo(Integer value) {
            addCriterion("Pcs >=", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsLessThan(Integer value) {
            addCriterion("Pcs <", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsLessThanOrEqualTo(Integer value) {
            addCriterion("Pcs <=", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsIn(List<Integer> values) {
            addCriterion("Pcs in", values, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsNotIn(List<Integer> values) {
            addCriterion("Pcs not in", values, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsBetween(Integer value1, Integer value2) {
            addCriterion("Pcs between", value1, value2, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsNotBetween(Integer value1, Integer value2) {
            addCriterion("Pcs not between", value1, value2, "pcs");
            return (Criteria) this;
        }

        public Criteria andOddIsNull() {
            addCriterion("Odd is null");
            return (Criteria) this;
        }

        public Criteria andOddIsNotNull() {
            addCriterion("Odd is not null");
            return (Criteria) this;
        }

        public Criteria andOddEqualTo(BigDecimal value) {
            addCriterion("Odd =", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddNotEqualTo(BigDecimal value) {
            addCriterion("Odd <>", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddGreaterThan(BigDecimal value) {
            addCriterion("Odd >", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Odd >=", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddLessThan(BigDecimal value) {
            addCriterion("Odd <", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Odd <=", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddIn(List<BigDecimal> values) {
            addCriterion("Odd in", values, "odd");
            return (Criteria) this;
        }

        public Criteria andOddNotIn(List<BigDecimal> values) {
            addCriterion("Odd not in", values, "odd");
            return (Criteria) this;
        }

        public Criteria andOddBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Odd between", value1, value2, "odd");
            return (Criteria) this;
        }

        public Criteria andOddNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Odd not between", value1, value2, "odd");
            return (Criteria) this;
        }

        public Criteria andQtyIsNull() {
            addCriterion("Qty is null");
            return (Criteria) this;
        }

        public Criteria andQtyIsNotNull() {
            addCriterion("Qty is not null");
            return (Criteria) this;
        }

        public Criteria andQtyEqualTo(BigDecimal value) {
            addCriterion("Qty =", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotEqualTo(BigDecimal value) {
            addCriterion("Qty <>", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThan(BigDecimal value) {
            addCriterion("Qty >", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty >=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThan(BigDecimal value) {
            addCriterion("Qty <", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty <=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyIn(List<BigDecimal> values) {
            addCriterion("Qty in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotIn(List<BigDecimal> values) {
            addCriterion("Qty not in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty not between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsIsNull() {
            addCriterion("AcceptPcs is null");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsIsNotNull() {
            addCriterion("AcceptPcs is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsEqualTo(Integer value) {
            addCriterion("AcceptPcs =", value, "acceptpcs");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsNotEqualTo(Integer value) {
            addCriterion("AcceptPcs <>", value, "acceptpcs");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsGreaterThan(Integer value) {
            addCriterion("AcceptPcs >", value, "acceptpcs");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsGreaterThanOrEqualTo(Integer value) {
            addCriterion("AcceptPcs >=", value, "acceptpcs");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsLessThan(Integer value) {
            addCriterion("AcceptPcs <", value, "acceptpcs");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsLessThanOrEqualTo(Integer value) {
            addCriterion("AcceptPcs <=", value, "acceptpcs");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsIn(List<Integer> values) {
            addCriterion("AcceptPcs in", values, "acceptpcs");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsNotIn(List<Integer> values) {
            addCriterion("AcceptPcs not in", values, "acceptpcs");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsBetween(Integer value1, Integer value2) {
            addCriterion("AcceptPcs between", value1, value2, "acceptpcs");
            return (Criteria) this;
        }

        public Criteria andAcceptpcsNotBetween(Integer value1, Integer value2) {
            addCriterion("AcceptPcs not between", value1, value2, "acceptpcs");
            return (Criteria) this;
        }

        public Criteria andAcceptoddIsNull() {
            addCriterion("AcceptOdd is null");
            return (Criteria) this;
        }

        public Criteria andAcceptoddIsNotNull() {
            addCriterion("AcceptOdd is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptoddEqualTo(BigDecimal value) {
            addCriterion("AcceptOdd =", value, "acceptodd");
            return (Criteria) this;
        }

        public Criteria andAcceptoddNotEqualTo(BigDecimal value) {
            addCriterion("AcceptOdd <>", value, "acceptodd");
            return (Criteria) this;
        }

        public Criteria andAcceptoddGreaterThan(BigDecimal value) {
            addCriterion("AcceptOdd >", value, "acceptodd");
            return (Criteria) this;
        }

        public Criteria andAcceptoddGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AcceptOdd >=", value, "acceptodd");
            return (Criteria) this;
        }

        public Criteria andAcceptoddLessThan(BigDecimal value) {
            addCriterion("AcceptOdd <", value, "acceptodd");
            return (Criteria) this;
        }

        public Criteria andAcceptoddLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AcceptOdd <=", value, "acceptodd");
            return (Criteria) this;
        }

        public Criteria andAcceptoddIn(List<BigDecimal> values) {
            addCriterion("AcceptOdd in", values, "acceptodd");
            return (Criteria) this;
        }

        public Criteria andAcceptoddNotIn(List<BigDecimal> values) {
            addCriterion("AcceptOdd not in", values, "acceptodd");
            return (Criteria) this;
        }

        public Criteria andAcceptoddBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AcceptOdd between", value1, value2, "acceptodd");
            return (Criteria) this;
        }

        public Criteria andAcceptoddNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AcceptOdd not between", value1, value2, "acceptodd");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyIsNull() {
            addCriterion("AcceptQty is null");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyIsNotNull() {
            addCriterion("AcceptQty is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyEqualTo(BigDecimal value) {
            addCriterion("AcceptQty =", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyNotEqualTo(BigDecimal value) {
            addCriterion("AcceptQty <>", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyGreaterThan(BigDecimal value) {
            addCriterion("AcceptQty >", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AcceptQty >=", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyLessThan(BigDecimal value) {
            addCriterion("AcceptQty <", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AcceptQty <=", value, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyIn(List<BigDecimal> values) {
            addCriterion("AcceptQty in", values, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyNotIn(List<BigDecimal> values) {
            addCriterion("AcceptQty not in", values, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AcceptQty between", value1, value2, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andAcceptqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AcceptQty not between", value1, value2, "acceptqty");
            return (Criteria) this;
        }

        public Criteria andGpcsIsNull() {
            addCriterion("GPcs is null");
            return (Criteria) this;
        }

        public Criteria andGpcsIsNotNull() {
            addCriterion("GPcs is not null");
            return (Criteria) this;
        }

        public Criteria andGpcsEqualTo(Integer value) {
            addCriterion("GPcs =", value, "gpcs");
            return (Criteria) this;
        }

        public Criteria andGpcsNotEqualTo(Integer value) {
            addCriterion("GPcs <>", value, "gpcs");
            return (Criteria) this;
        }

        public Criteria andGpcsGreaterThan(Integer value) {
            addCriterion("GPcs >", value, "gpcs");
            return (Criteria) this;
        }

        public Criteria andGpcsGreaterThanOrEqualTo(Integer value) {
            addCriterion("GPcs >=", value, "gpcs");
            return (Criteria) this;
        }

        public Criteria andGpcsLessThan(Integer value) {
            addCriterion("GPcs <", value, "gpcs");
            return (Criteria) this;
        }

        public Criteria andGpcsLessThanOrEqualTo(Integer value) {
            addCriterion("GPcs <=", value, "gpcs");
            return (Criteria) this;
        }

        public Criteria andGpcsIn(List<Integer> values) {
            addCriterion("GPcs in", values, "gpcs");
            return (Criteria) this;
        }

        public Criteria andGpcsNotIn(List<Integer> values) {
            addCriterion("GPcs not in", values, "gpcs");
            return (Criteria) this;
        }

        public Criteria andGpcsBetween(Integer value1, Integer value2) {
            addCriterion("GPcs between", value1, value2, "gpcs");
            return (Criteria) this;
        }

        public Criteria andGpcsNotBetween(Integer value1, Integer value2) {
            addCriterion("GPcs not between", value1, value2, "gpcs");
            return (Criteria) this;
        }

        public Criteria andGoddIsNull() {
            addCriterion("GOdd is null");
            return (Criteria) this;
        }

        public Criteria andGoddIsNotNull() {
            addCriterion("GOdd is not null");
            return (Criteria) this;
        }

        public Criteria andGoddEqualTo(BigDecimal value) {
            addCriterion("GOdd =", value, "godd");
            return (Criteria) this;
        }

        public Criteria andGoddNotEqualTo(BigDecimal value) {
            addCriterion("GOdd <>", value, "godd");
            return (Criteria) this;
        }

        public Criteria andGoddGreaterThan(BigDecimal value) {
            addCriterion("GOdd >", value, "godd");
            return (Criteria) this;
        }

        public Criteria andGoddGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("GOdd >=", value, "godd");
            return (Criteria) this;
        }

        public Criteria andGoddLessThan(BigDecimal value) {
            addCriterion("GOdd <", value, "godd");
            return (Criteria) this;
        }

        public Criteria andGoddLessThanOrEqualTo(BigDecimal value) {
            addCriterion("GOdd <=", value, "godd");
            return (Criteria) this;
        }

        public Criteria andGoddIn(List<BigDecimal> values) {
            addCriterion("GOdd in", values, "godd");
            return (Criteria) this;
        }

        public Criteria andGoddNotIn(List<BigDecimal> values) {
            addCriterion("GOdd not in", values, "godd");
            return (Criteria) this;
        }

        public Criteria andGoddBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GOdd between", value1, value2, "godd");
            return (Criteria) this;
        }

        public Criteria andGoddNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GOdd not between", value1, value2, "godd");
            return (Criteria) this;
        }

        public Criteria andGqtyIsNull() {
            addCriterion("GQty is null");
            return (Criteria) this;
        }

        public Criteria andGqtyIsNotNull() {
            addCriterion("GQty is not null");
            return (Criteria) this;
        }

        public Criteria andGqtyEqualTo(BigDecimal value) {
            addCriterion("GQty =", value, "gqty");
            return (Criteria) this;
        }

        public Criteria andGqtyNotEqualTo(BigDecimal value) {
            addCriterion("GQty <>", value, "gqty");
            return (Criteria) this;
        }

        public Criteria andGqtyGreaterThan(BigDecimal value) {
            addCriterion("GQty >", value, "gqty");
            return (Criteria) this;
        }

        public Criteria andGqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("GQty >=", value, "gqty");
            return (Criteria) this;
        }

        public Criteria andGqtyLessThan(BigDecimal value) {
            addCriterion("GQty <", value, "gqty");
            return (Criteria) this;
        }

        public Criteria andGqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("GQty <=", value, "gqty");
            return (Criteria) this;
        }

        public Criteria andGqtyIn(List<BigDecimal> values) {
            addCriterion("GQty in", values, "gqty");
            return (Criteria) this;
        }

        public Criteria andGqtyNotIn(List<BigDecimal> values) {
            addCriterion("GQty not in", values, "gqty");
            return (Criteria) this;
        }

        public Criteria andGqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GQty between", value1, value2, "gqty");
            return (Criteria) this;
        }

        public Criteria andGqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GQty not between", value1, value2, "gqty");
            return (Criteria) this;
        }

        public Criteria andSalepcsIsNull() {
            addCriterion("SalePcs is null");
            return (Criteria) this;
        }

        public Criteria andSalepcsIsNotNull() {
            addCriterion("SalePcs is not null");
            return (Criteria) this;
        }

        public Criteria andSalepcsEqualTo(Integer value) {
            addCriterion("SalePcs =", value, "salepcs");
            return (Criteria) this;
        }

        public Criteria andSalepcsNotEqualTo(Integer value) {
            addCriterion("SalePcs <>", value, "salepcs");
            return (Criteria) this;
        }

        public Criteria andSalepcsGreaterThan(Integer value) {
            addCriterion("SalePcs >", value, "salepcs");
            return (Criteria) this;
        }

        public Criteria andSalepcsGreaterThanOrEqualTo(Integer value) {
            addCriterion("SalePcs >=", value, "salepcs");
            return (Criteria) this;
        }

        public Criteria andSalepcsLessThan(Integer value) {
            addCriterion("SalePcs <", value, "salepcs");
            return (Criteria) this;
        }

        public Criteria andSalepcsLessThanOrEqualTo(Integer value) {
            addCriterion("SalePcs <=", value, "salepcs");
            return (Criteria) this;
        }

        public Criteria andSalepcsIn(List<Integer> values) {
            addCriterion("SalePcs in", values, "salepcs");
            return (Criteria) this;
        }

        public Criteria andSalepcsNotIn(List<Integer> values) {
            addCriterion("SalePcs not in", values, "salepcs");
            return (Criteria) this;
        }

        public Criteria andSalepcsBetween(Integer value1, Integer value2) {
            addCriterion("SalePcs between", value1, value2, "salepcs");
            return (Criteria) this;
        }

        public Criteria andSalepcsNotBetween(Integer value1, Integer value2) {
            addCriterion("SalePcs not between", value1, value2, "salepcs");
            return (Criteria) this;
        }

        public Criteria andSaleoddIsNull() {
            addCriterion("SaleOdd is null");
            return (Criteria) this;
        }

        public Criteria andSaleoddIsNotNull() {
            addCriterion("SaleOdd is not null");
            return (Criteria) this;
        }

        public Criteria andSaleoddEqualTo(BigDecimal value) {
            addCriterion("SaleOdd =", value, "saleodd");
            return (Criteria) this;
        }

        public Criteria andSaleoddNotEqualTo(BigDecimal value) {
            addCriterion("SaleOdd <>", value, "saleodd");
            return (Criteria) this;
        }

        public Criteria andSaleoddGreaterThan(BigDecimal value) {
            addCriterion("SaleOdd >", value, "saleodd");
            return (Criteria) this;
        }

        public Criteria andSaleoddGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleOdd >=", value, "saleodd");
            return (Criteria) this;
        }

        public Criteria andSaleoddLessThan(BigDecimal value) {
            addCriterion("SaleOdd <", value, "saleodd");
            return (Criteria) this;
        }

        public Criteria andSaleoddLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleOdd <=", value, "saleodd");
            return (Criteria) this;
        }

        public Criteria andSaleoddIn(List<BigDecimal> values) {
            addCriterion("SaleOdd in", values, "saleodd");
            return (Criteria) this;
        }

        public Criteria andSaleoddNotIn(List<BigDecimal> values) {
            addCriterion("SaleOdd not in", values, "saleodd");
            return (Criteria) this;
        }

        public Criteria andSaleoddBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleOdd between", value1, value2, "saleodd");
            return (Criteria) this;
        }

        public Criteria andSaleoddNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleOdd not between", value1, value2, "saleodd");
            return (Criteria) this;
        }

        public Criteria andSaleqtyIsNull() {
            addCriterion("SaleQty is null");
            return (Criteria) this;
        }

        public Criteria andSaleqtyIsNotNull() {
            addCriterion("SaleQty is not null");
            return (Criteria) this;
        }

        public Criteria andSaleqtyEqualTo(BigDecimal value) {
            addCriterion("SaleQty =", value, "saleqty");
            return (Criteria) this;
        }

        public Criteria andSaleqtyNotEqualTo(BigDecimal value) {
            addCriterion("SaleQty <>", value, "saleqty");
            return (Criteria) this;
        }

        public Criteria andSaleqtyGreaterThan(BigDecimal value) {
            addCriterion("SaleQty >", value, "saleqty");
            return (Criteria) this;
        }

        public Criteria andSaleqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleQty >=", value, "saleqty");
            return (Criteria) this;
        }

        public Criteria andSaleqtyLessThan(BigDecimal value) {
            addCriterion("SaleQty <", value, "saleqty");
            return (Criteria) this;
        }

        public Criteria andSaleqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleQty <=", value, "saleqty");
            return (Criteria) this;
        }

        public Criteria andSaleqtyIn(List<BigDecimal> values) {
            addCriterion("SaleQty in", values, "saleqty");
            return (Criteria) this;
        }

        public Criteria andSaleqtyNotIn(List<BigDecimal> values) {
            addCriterion("SaleQty not in", values, "saleqty");
            return (Criteria) this;
        }

        public Criteria andSaleqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleQty between", value1, value2, "saleqty");
            return (Criteria) this;
        }

        public Criteria andSaleqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleQty not between", value1, value2, "saleqty");
            return (Criteria) this;
        }

        public Criteria andSalegqtyIsNull() {
            addCriterion("SaleGQty is null");
            return (Criteria) this;
        }

        public Criteria andSalegqtyIsNotNull() {
            addCriterion("SaleGQty is not null");
            return (Criteria) this;
        }

        public Criteria andSalegqtyEqualTo(BigDecimal value) {
            addCriterion("SaleGQty =", value, "salegqty");
            return (Criteria) this;
        }

        public Criteria andSalegqtyNotEqualTo(BigDecimal value) {
            addCriterion("SaleGQty <>", value, "salegqty");
            return (Criteria) this;
        }

        public Criteria andSalegqtyGreaterThan(BigDecimal value) {
            addCriterion("SaleGQty >", value, "salegqty");
            return (Criteria) this;
        }

        public Criteria andSalegqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleGQty >=", value, "salegqty");
            return (Criteria) this;
        }

        public Criteria andSalegqtyLessThan(BigDecimal value) {
            addCriterion("SaleGQty <", value, "salegqty");
            return (Criteria) this;
        }

        public Criteria andSalegqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleGQty <=", value, "salegqty");
            return (Criteria) this;
        }

        public Criteria andSalegqtyIn(List<BigDecimal> values) {
            addCriterion("SaleGQty in", values, "salegqty");
            return (Criteria) this;
        }

        public Criteria andSalegqtyNotIn(List<BigDecimal> values) {
            addCriterion("SaleGQty not in", values, "salegqty");
            return (Criteria) this;
        }

        public Criteria andSalegqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleGQty between", value1, value2, "salegqty");
            return (Criteria) this;
        }

        public Criteria andSalegqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleGQty not between", value1, value2, "salegqty");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("Price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("Price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("Price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("Price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("Price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("Price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("Price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("Price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andNetpriceIsNull() {
            addCriterion("NetPrice is null");
            return (Criteria) this;
        }

        public Criteria andNetpriceIsNotNull() {
            addCriterion("NetPrice is not null");
            return (Criteria) this;
        }

        public Criteria andNetpriceEqualTo(BigDecimal value) {
            addCriterion("NetPrice =", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceNotEqualTo(BigDecimal value) {
            addCriterion("NetPrice <>", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceGreaterThan(BigDecimal value) {
            addCriterion("NetPrice >", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("NetPrice >=", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceLessThan(BigDecimal value) {
            addCriterion("NetPrice <", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("NetPrice <=", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceIn(List<BigDecimal> values) {
            addCriterion("NetPrice in", values, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceNotIn(List<BigDecimal> values) {
            addCriterion("NetPrice not in", values, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NetPrice between", value1, value2, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NetPrice not between", value1, value2, "netprice");
            return (Criteria) this;
        }

        public Criteria andWspriceIsNull() {
            addCriterion("WSPrice is null");
            return (Criteria) this;
        }

        public Criteria andWspriceIsNotNull() {
            addCriterion("WSPrice is not null");
            return (Criteria) this;
        }

        public Criteria andWspriceEqualTo(BigDecimal value) {
            addCriterion("WSPrice =", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceNotEqualTo(BigDecimal value) {
            addCriterion("WSPrice <>", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceGreaterThan(BigDecimal value) {
            addCriterion("WSPrice >", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WSPrice >=", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceLessThan(BigDecimal value) {
            addCriterion("WSPrice <", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WSPrice <=", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceIn(List<BigDecimal> values) {
            addCriterion("WSPrice in", values, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceNotIn(List<BigDecimal> values) {
            addCriterion("WSPrice not in", values, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WSPrice between", value1, value2, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WSPrice not between", value1, value2, "wsprice");
            return (Criteria) this;
        }

        public Criteria andTradesptagIsNull() {
            addCriterion("TradeSpTag is null");
            return (Criteria) this;
        }

        public Criteria andTradesptagIsNotNull() {
            addCriterion("TradeSpTag is not null");
            return (Criteria) this;
        }

        public Criteria andTradesptagEqualTo(String value) {
            addCriterion("TradeSpTag =", value, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagNotEqualTo(String value) {
            addCriterion("TradeSpTag <>", value, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagGreaterThan(String value) {
            addCriterion("TradeSpTag >", value, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagGreaterThanOrEqualTo(String value) {
            addCriterion("TradeSpTag >=", value, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagLessThan(String value) {
            addCriterion("TradeSpTag <", value, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagLessThanOrEqualTo(String value) {
            addCriterion("TradeSpTag <=", value, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagLike(String value) {
            addCriterion("TradeSpTag like", value, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagNotLike(String value) {
            addCriterion("TradeSpTag not like", value, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagIn(List<String> values) {
            addCriterion("TradeSpTag in", values, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagNotIn(List<String> values) {
            addCriterion("TradeSpTag not in", values, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagBetween(String value1, String value2) {
            addCriterion("TradeSpTag between", value1, value2, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andTradesptagNotBetween(String value1, String value2) {
            addCriterion("TradeSpTag not between", value1, value2, "tradesptag");
            return (Criteria) this;
        }

        public Criteria andWsdiscIsNull() {
            addCriterion("WSDisc is null");
            return (Criteria) this;
        }

        public Criteria andWsdiscIsNotNull() {
            addCriterion("WSDisc is not null");
            return (Criteria) this;
        }

        public Criteria andWsdiscEqualTo(BigDecimal value) {
            addCriterion("WSDisc =", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscNotEqualTo(BigDecimal value) {
            addCriterion("WSDisc <>", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscGreaterThan(BigDecimal value) {
            addCriterion("WSDisc >", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WSDisc >=", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscLessThan(BigDecimal value) {
            addCriterion("WSDisc <", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WSDisc <=", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscIn(List<BigDecimal> values) {
            addCriterion("WSDisc in", values, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscNotIn(List<BigDecimal> values) {
            addCriterion("WSDisc not in", values, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WSDisc between", value1, value2, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WSDisc not between", value1, value2, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andSalediscIsNull() {
            addCriterion("SaleDisc is null");
            return (Criteria) this;
        }

        public Criteria andSalediscIsNotNull() {
            addCriterion("SaleDisc is not null");
            return (Criteria) this;
        }

        public Criteria andSalediscEqualTo(BigDecimal value) {
            addCriterion("SaleDisc =", value, "saledisc");
            return (Criteria) this;
        }

        public Criteria andSalediscNotEqualTo(BigDecimal value) {
            addCriterion("SaleDisc <>", value, "saledisc");
            return (Criteria) this;
        }

        public Criteria andSalediscGreaterThan(BigDecimal value) {
            addCriterion("SaleDisc >", value, "saledisc");
            return (Criteria) this;
        }

        public Criteria andSalediscGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleDisc >=", value, "saledisc");
            return (Criteria) this;
        }

        public Criteria andSalediscLessThan(BigDecimal value) {
            addCriterion("SaleDisc <", value, "saledisc");
            return (Criteria) this;
        }

        public Criteria andSalediscLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleDisc <=", value, "saledisc");
            return (Criteria) this;
        }

        public Criteria andSalediscIn(List<BigDecimal> values) {
            addCriterion("SaleDisc in", values, "saledisc");
            return (Criteria) this;
        }

        public Criteria andSalediscNotIn(List<BigDecimal> values) {
            addCriterion("SaleDisc not in", values, "saledisc");
            return (Criteria) this;
        }

        public Criteria andSalediscBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleDisc between", value1, value2, "saledisc");
            return (Criteria) this;
        }

        public Criteria andSalediscNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleDisc not between", value1, value2, "saledisc");
            return (Criteria) this;
        }

        public Criteria andSalepriceIsNull() {
            addCriterion("SalePrice is null");
            return (Criteria) this;
        }

        public Criteria andSalepriceIsNotNull() {
            addCriterion("SalePrice is not null");
            return (Criteria) this;
        }

        public Criteria andSalepriceEqualTo(BigDecimal value) {
            addCriterion("SalePrice =", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotEqualTo(BigDecimal value) {
            addCriterion("SalePrice <>", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceGreaterThan(BigDecimal value) {
            addCriterion("SalePrice >", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SalePrice >=", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceLessThan(BigDecimal value) {
            addCriterion("SalePrice <", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SalePrice <=", value, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceIn(List<BigDecimal> values) {
            addCriterion("SalePrice in", values, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotIn(List<BigDecimal> values) {
            addCriterion("SalePrice not in", values, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SalePrice between", value1, value2, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalepriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SalePrice not between", value1, value2, "saleprice");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceIsNull() {
            addCriterion("SaleNetPrice is null");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceIsNotNull() {
            addCriterion("SaleNetPrice is not null");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceEqualTo(BigDecimal value) {
            addCriterion("SaleNetPrice =", value, "salenetprice");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceNotEqualTo(BigDecimal value) {
            addCriterion("SaleNetPrice <>", value, "salenetprice");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceGreaterThan(BigDecimal value) {
            addCriterion("SaleNetPrice >", value, "salenetprice");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleNetPrice >=", value, "salenetprice");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceLessThan(BigDecimal value) {
            addCriterion("SaleNetPrice <", value, "salenetprice");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleNetPrice <=", value, "salenetprice");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceIn(List<BigDecimal> values) {
            addCriterion("SaleNetPrice in", values, "salenetprice");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceNotIn(List<BigDecimal> values) {
            addCriterion("SaleNetPrice not in", values, "salenetprice");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleNetPrice between", value1, value2, "salenetprice");
            return (Criteria) this;
        }

        public Criteria andSalenetpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleNetPrice not between", value1, value2, "salenetprice");
            return (Criteria) this;
        }

        public Criteria andSalepricetagIsNull() {
            addCriterion("SalePriceTag is null");
            return (Criteria) this;
        }

        public Criteria andSalepricetagIsNotNull() {
            addCriterion("SalePriceTag is not null");
            return (Criteria) this;
        }

        public Criteria andSalepricetagEqualTo(String value) {
            addCriterion("SalePriceTag =", value, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagNotEqualTo(String value) {
            addCriterion("SalePriceTag <>", value, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagGreaterThan(String value) {
            addCriterion("SalePriceTag >", value, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagGreaterThanOrEqualTo(String value) {
            addCriterion("SalePriceTag >=", value, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagLessThan(String value) {
            addCriterion("SalePriceTag <", value, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagLessThanOrEqualTo(String value) {
            addCriterion("SalePriceTag <=", value, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagLike(String value) {
            addCriterion("SalePriceTag like", value, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagNotLike(String value) {
            addCriterion("SalePriceTag not like", value, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagIn(List<String> values) {
            addCriterion("SalePriceTag in", values, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagNotIn(List<String> values) {
            addCriterion("SalePriceTag not in", values, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagBetween(String value1, String value2) {
            addCriterion("SalePriceTag between", value1, value2, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andSalepricetagNotBetween(String value1, String value2) {
            addCriterion("SalePriceTag not between", value1, value2, "salepricetag");
            return (Criteria) this;
        }

        public Criteria andCostIsNull() {
            addCriterion("Cost is null");
            return (Criteria) this;
        }

        public Criteria andCostIsNotNull() {
            addCriterion("Cost is not null");
            return (Criteria) this;
        }

        public Criteria andCostEqualTo(BigDecimal value) {
            addCriterion("Cost =", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotEqualTo(BigDecimal value) {
            addCriterion("Cost <>", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostGreaterThan(BigDecimal value) {
            addCriterion("Cost >", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Cost >=", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostLessThan(BigDecimal value) {
            addCriterion("Cost <", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Cost <=", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostIn(List<BigDecimal> values) {
            addCriterion("Cost in", values, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotIn(List<BigDecimal> values) {
            addCriterion("Cost not in", values, "cost");
            return (Criteria) this;
        }

        public Criteria andCostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Cost between", value1, value2, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Cost not between", value1, value2, "cost");
            return (Criteria) this;
        }

        public Criteria andNetcostIsNull() {
            addCriterion("NetCost is null");
            return (Criteria) this;
        }

        public Criteria andNetcostIsNotNull() {
            addCriterion("NetCost is not null");
            return (Criteria) this;
        }

        public Criteria andNetcostEqualTo(BigDecimal value) {
            addCriterion("NetCost =", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostNotEqualTo(BigDecimal value) {
            addCriterion("NetCost <>", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostGreaterThan(BigDecimal value) {
            addCriterion("NetCost >", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("NetCost >=", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostLessThan(BigDecimal value) {
            addCriterion("NetCost <", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("NetCost <=", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostIn(List<BigDecimal> values) {
            addCriterion("NetCost in", values, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostNotIn(List<BigDecimal> values) {
            addCriterion("NetCost not in", values, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NetCost between", value1, value2, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NetCost not between", value1, value2, "netcost");
            return (Criteria) this;
        }

        public Criteria andAcceptamtIsNull() {
            addCriterion("AcceptAmt is null");
            return (Criteria) this;
        }

        public Criteria andAcceptamtIsNotNull() {
            addCriterion("AcceptAmt is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptamtEqualTo(BigDecimal value) {
            addCriterion("AcceptAmt =", value, "acceptamt");
            return (Criteria) this;
        }

        public Criteria andAcceptamtNotEqualTo(BigDecimal value) {
            addCriterion("AcceptAmt <>", value, "acceptamt");
            return (Criteria) this;
        }

        public Criteria andAcceptamtGreaterThan(BigDecimal value) {
            addCriterion("AcceptAmt >", value, "acceptamt");
            return (Criteria) this;
        }

        public Criteria andAcceptamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AcceptAmt >=", value, "acceptamt");
            return (Criteria) this;
        }

        public Criteria andAcceptamtLessThan(BigDecimal value) {
            addCriterion("AcceptAmt <", value, "acceptamt");
            return (Criteria) this;
        }

        public Criteria andAcceptamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AcceptAmt <=", value, "acceptamt");
            return (Criteria) this;
        }

        public Criteria andAcceptamtIn(List<BigDecimal> values) {
            addCriterion("AcceptAmt in", values, "acceptamt");
            return (Criteria) this;
        }

        public Criteria andAcceptamtNotIn(List<BigDecimal> values) {
            addCriterion("AcceptAmt not in", values, "acceptamt");
            return (Criteria) this;
        }

        public Criteria andAcceptamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AcceptAmt between", value1, value2, "acceptamt");
            return (Criteria) this;
        }

        public Criteria andAcceptamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AcceptAmt not between", value1, value2, "acceptamt");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtIsNull() {
            addCriterion("AcceptNetAmt is null");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtIsNotNull() {
            addCriterion("AcceptNetAmt is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtEqualTo(BigDecimal value) {
            addCriterion("AcceptNetAmt =", value, "acceptnetamt");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtNotEqualTo(BigDecimal value) {
            addCriterion("AcceptNetAmt <>", value, "acceptnetamt");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtGreaterThan(BigDecimal value) {
            addCriterion("AcceptNetAmt >", value, "acceptnetamt");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AcceptNetAmt >=", value, "acceptnetamt");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtLessThan(BigDecimal value) {
            addCriterion("AcceptNetAmt <", value, "acceptnetamt");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AcceptNetAmt <=", value, "acceptnetamt");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtIn(List<BigDecimal> values) {
            addCriterion("AcceptNetAmt in", values, "acceptnetamt");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtNotIn(List<BigDecimal> values) {
            addCriterion("AcceptNetAmt not in", values, "acceptnetamt");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AcceptNetAmt between", value1, value2, "acceptnetamt");
            return (Criteria) this;
        }

        public Criteria andAcceptnetamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AcceptNetAmt not between", value1, value2, "acceptnetamt");
            return (Criteria) this;
        }

        public Criteria andBalancetagIsNull() {
            addCriterion("BalanceTag is null");
            return (Criteria) this;
        }

        public Criteria andBalancetagIsNotNull() {
            addCriterion("BalanceTag is not null");
            return (Criteria) this;
        }

        public Criteria andBalancetagEqualTo(String value) {
            addCriterion("BalanceTag =", value, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagNotEqualTo(String value) {
            addCriterion("BalanceTag <>", value, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagGreaterThan(String value) {
            addCriterion("BalanceTag >", value, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagGreaterThanOrEqualTo(String value) {
            addCriterion("BalanceTag >=", value, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagLessThan(String value) {
            addCriterion("BalanceTag <", value, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagLessThanOrEqualTo(String value) {
            addCriterion("BalanceTag <=", value, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagLike(String value) {
            addCriterion("BalanceTag like", value, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagNotLike(String value) {
            addCriterion("BalanceTag not like", value, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagIn(List<String> values) {
            addCriterion("BalanceTag in", values, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagNotIn(List<String> values) {
            addCriterion("BalanceTag not in", values, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagBetween(String value1, String value2) {
            addCriterion("BalanceTag between", value1, value2, "balancetag");
            return (Criteria) this;
        }

        public Criteria andBalancetagNotBetween(String value1, String value2) {
            addCriterion("BalanceTag not between", value1, value2, "balancetag");
            return (Criteria) this;
        }

        public Criteria andSaleamtIsNull() {
            addCriterion("SaleAmt is null");
            return (Criteria) this;
        }

        public Criteria andSaleamtIsNotNull() {
            addCriterion("SaleAmt is not null");
            return (Criteria) this;
        }

        public Criteria andSaleamtEqualTo(BigDecimal value) {
            addCriterion("SaleAmt =", value, "saleamt");
            return (Criteria) this;
        }

        public Criteria andSaleamtNotEqualTo(BigDecimal value) {
            addCriterion("SaleAmt <>", value, "saleamt");
            return (Criteria) this;
        }

        public Criteria andSaleamtGreaterThan(BigDecimal value) {
            addCriterion("SaleAmt >", value, "saleamt");
            return (Criteria) this;
        }

        public Criteria andSaleamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleAmt >=", value, "saleamt");
            return (Criteria) this;
        }

        public Criteria andSaleamtLessThan(BigDecimal value) {
            addCriterion("SaleAmt <", value, "saleamt");
            return (Criteria) this;
        }

        public Criteria andSaleamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleAmt <=", value, "saleamt");
            return (Criteria) this;
        }

        public Criteria andSaleamtIn(List<BigDecimal> values) {
            addCriterion("SaleAmt in", values, "saleamt");
            return (Criteria) this;
        }

        public Criteria andSaleamtNotIn(List<BigDecimal> values) {
            addCriterion("SaleAmt not in", values, "saleamt");
            return (Criteria) this;
        }

        public Criteria andSaleamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleAmt between", value1, value2, "saleamt");
            return (Criteria) this;
        }

        public Criteria andSaleamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleAmt not between", value1, value2, "saleamt");
            return (Criteria) this;
        }

        public Criteria andSalenetamtIsNull() {
            addCriterion("SaleNetAmt is null");
            return (Criteria) this;
        }

        public Criteria andSalenetamtIsNotNull() {
            addCriterion("SaleNetAmt is not null");
            return (Criteria) this;
        }

        public Criteria andSalenetamtEqualTo(BigDecimal value) {
            addCriterion("SaleNetAmt =", value, "salenetamt");
            return (Criteria) this;
        }

        public Criteria andSalenetamtNotEqualTo(BigDecimal value) {
            addCriterion("SaleNetAmt <>", value, "salenetamt");
            return (Criteria) this;
        }

        public Criteria andSalenetamtGreaterThan(BigDecimal value) {
            addCriterion("SaleNetAmt >", value, "salenetamt");
            return (Criteria) this;
        }

        public Criteria andSalenetamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleNetAmt >=", value, "salenetamt");
            return (Criteria) this;
        }

        public Criteria andSalenetamtLessThan(BigDecimal value) {
            addCriterion("SaleNetAmt <", value, "salenetamt");
            return (Criteria) this;
        }

        public Criteria andSalenetamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleNetAmt <=", value, "salenetamt");
            return (Criteria) this;
        }

        public Criteria andSalenetamtIn(List<BigDecimal> values) {
            addCriterion("SaleNetAmt in", values, "salenetamt");
            return (Criteria) this;
        }

        public Criteria andSalenetamtNotIn(List<BigDecimal> values) {
            addCriterion("SaleNetAmt not in", values, "salenetamt");
            return (Criteria) this;
        }

        public Criteria andSalenetamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleNetAmt between", value1, value2, "salenetamt");
            return (Criteria) this;
        }

        public Criteria andSalenetamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleNetAmt not between", value1, value2, "salenetamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtIsNull() {
            addCriterion("WriteOffAmt is null");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtIsNotNull() {
            addCriterion("WriteOffAmt is not null");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtEqualTo(BigDecimal value) {
            addCriterion("WriteOffAmt =", value, "writeoffamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtNotEqualTo(BigDecimal value) {
            addCriterion("WriteOffAmt <>", value, "writeoffamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtGreaterThan(BigDecimal value) {
            addCriterion("WriteOffAmt >", value, "writeoffamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WriteOffAmt >=", value, "writeoffamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtLessThan(BigDecimal value) {
            addCriterion("WriteOffAmt <", value, "writeoffamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WriteOffAmt <=", value, "writeoffamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtIn(List<BigDecimal> values) {
            addCriterion("WriteOffAmt in", values, "writeoffamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtNotIn(List<BigDecimal> values) {
            addCriterion("WriteOffAmt not in", values, "writeoffamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WriteOffAmt between", value1, value2, "writeoffamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WriteOffAmt not between", value1, value2, "writeoffamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtIsNull() {
            addCriterion("WriteOffNetAmt is null");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtIsNotNull() {
            addCriterion("WriteOffNetAmt is not null");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtEqualTo(BigDecimal value) {
            addCriterion("WriteOffNetAmt =", value, "writeoffnetamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtNotEqualTo(BigDecimal value) {
            addCriterion("WriteOffNetAmt <>", value, "writeoffnetamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtGreaterThan(BigDecimal value) {
            addCriterion("WriteOffNetAmt >", value, "writeoffnetamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WriteOffNetAmt >=", value, "writeoffnetamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtLessThan(BigDecimal value) {
            addCriterion("WriteOffNetAmt <", value, "writeoffnetamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WriteOffNetAmt <=", value, "writeoffnetamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtIn(List<BigDecimal> values) {
            addCriterion("WriteOffNetAmt in", values, "writeoffnetamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtNotIn(List<BigDecimal> values) {
            addCriterion("WriteOffNetAmt not in", values, "writeoffnetamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WriteOffNetAmt between", value1, value2, "writeoffnetamt");
            return (Criteria) this;
        }

        public Criteria andWriteoffnetamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WriteOffNetAmt not between", value1, value2, "writeoffnetamt");
            return (Criteria) this;
        }

        public Criteria andPaymentIsNull() {
            addCriterion("Payment is null");
            return (Criteria) this;
        }

        public Criteria andPaymentIsNotNull() {
            addCriterion("Payment is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentEqualTo(BigDecimal value) {
            addCriterion("Payment =", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentNotEqualTo(BigDecimal value) {
            addCriterion("Payment <>", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentGreaterThan(BigDecimal value) {
            addCriterion("Payment >", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Payment >=", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentLessThan(BigDecimal value) {
            addCriterion("Payment <", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Payment <=", value, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentIn(List<BigDecimal> values) {
            addCriterion("Payment in", values, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentNotIn(List<BigDecimal> values) {
            addCriterion("Payment not in", values, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Payment between", value1, value2, "payment");
            return (Criteria) this;
        }

        public Criteria andPaymentNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Payment not between", value1, value2, "payment");
            return (Criteria) this;
        }

        public Criteria andBaladiscIsNull() {
            addCriterion("BalaDisc is null");
            return (Criteria) this;
        }

        public Criteria andBaladiscIsNotNull() {
            addCriterion("BalaDisc is not null");
            return (Criteria) this;
        }

        public Criteria andBaladiscEqualTo(BigDecimal value) {
            addCriterion("BalaDisc =", value, "baladisc");
            return (Criteria) this;
        }

        public Criteria andBaladiscNotEqualTo(BigDecimal value) {
            addCriterion("BalaDisc <>", value, "baladisc");
            return (Criteria) this;
        }

        public Criteria andBaladiscGreaterThan(BigDecimal value) {
            addCriterion("BalaDisc >", value, "baladisc");
            return (Criteria) this;
        }

        public Criteria andBaladiscGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaDisc >=", value, "baladisc");
            return (Criteria) this;
        }

        public Criteria andBaladiscLessThan(BigDecimal value) {
            addCriterion("BalaDisc <", value, "baladisc");
            return (Criteria) this;
        }

        public Criteria andBaladiscLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaDisc <=", value, "baladisc");
            return (Criteria) this;
        }

        public Criteria andBaladiscIn(List<BigDecimal> values) {
            addCriterion("BalaDisc in", values, "baladisc");
            return (Criteria) this;
        }

        public Criteria andBaladiscNotIn(List<BigDecimal> values) {
            addCriterion("BalaDisc not in", values, "baladisc");
            return (Criteria) this;
        }

        public Criteria andBaladiscBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaDisc between", value1, value2, "baladisc");
            return (Criteria) this;
        }

        public Criteria andBaladiscNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaDisc not between", value1, value2, "baladisc");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtIsNull() {
            addCriterion("BalaDiscAmt is null");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtIsNotNull() {
            addCriterion("BalaDiscAmt is not null");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtEqualTo(BigDecimal value) {
            addCriterion("BalaDiscAmt =", value, "baladiscamt");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtNotEqualTo(BigDecimal value) {
            addCriterion("BalaDiscAmt <>", value, "baladiscamt");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtGreaterThan(BigDecimal value) {
            addCriterion("BalaDiscAmt >", value, "baladiscamt");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaDiscAmt >=", value, "baladiscamt");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtLessThan(BigDecimal value) {
            addCriterion("BalaDiscAmt <", value, "baladiscamt");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaDiscAmt <=", value, "baladiscamt");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtIn(List<BigDecimal> values) {
            addCriterion("BalaDiscAmt in", values, "baladiscamt");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtNotIn(List<BigDecimal> values) {
            addCriterion("BalaDiscAmt not in", values, "baladiscamt");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaDiscAmt between", value1, value2, "baladiscamt");
            return (Criteria) this;
        }

        public Criteria andBaladiscamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaDiscAmt not between", value1, value2, "baladiscamt");
            return (Criteria) this;
        }

        public Criteria andBaladiscountIsNull() {
            addCriterion("BalaDiscount is null");
            return (Criteria) this;
        }

        public Criteria andBaladiscountIsNotNull() {
            addCriterion("BalaDiscount is not null");
            return (Criteria) this;
        }

        public Criteria andBaladiscountEqualTo(BigDecimal value) {
            addCriterion("BalaDiscount =", value, "baladiscount");
            return (Criteria) this;
        }

        public Criteria andBaladiscountNotEqualTo(BigDecimal value) {
            addCriterion("BalaDiscount <>", value, "baladiscount");
            return (Criteria) this;
        }

        public Criteria andBaladiscountGreaterThan(BigDecimal value) {
            addCriterion("BalaDiscount >", value, "baladiscount");
            return (Criteria) this;
        }

        public Criteria andBaladiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaDiscount >=", value, "baladiscount");
            return (Criteria) this;
        }

        public Criteria andBaladiscountLessThan(BigDecimal value) {
            addCriterion("BalaDiscount <", value, "baladiscount");
            return (Criteria) this;
        }

        public Criteria andBaladiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaDiscount <=", value, "baladiscount");
            return (Criteria) this;
        }

        public Criteria andBaladiscountIn(List<BigDecimal> values) {
            addCriterion("BalaDiscount in", values, "baladiscount");
            return (Criteria) this;
        }

        public Criteria andBaladiscountNotIn(List<BigDecimal> values) {
            addCriterion("BalaDiscount not in", values, "baladiscount");
            return (Criteria) this;
        }

        public Criteria andBaladiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaDiscount between", value1, value2, "baladiscount");
            return (Criteria) this;
        }

        public Criteria andBaladiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaDiscount not between", value1, value2, "baladiscount");
            return (Criteria) this;
        }

        public Criteria andBalacycIsNull() {
            addCriterion("BalaCyc is null");
            return (Criteria) this;
        }

        public Criteria andBalacycIsNotNull() {
            addCriterion("BalaCyc is not null");
            return (Criteria) this;
        }

        public Criteria andBalacycEqualTo(Integer value) {
            addCriterion("BalaCyc =", value, "balacyc");
            return (Criteria) this;
        }

        public Criteria andBalacycNotEqualTo(Integer value) {
            addCriterion("BalaCyc <>", value, "balacyc");
            return (Criteria) this;
        }

        public Criteria andBalacycGreaterThan(Integer value) {
            addCriterion("BalaCyc >", value, "balacyc");
            return (Criteria) this;
        }

        public Criteria andBalacycGreaterThanOrEqualTo(Integer value) {
            addCriterion("BalaCyc >=", value, "balacyc");
            return (Criteria) this;
        }

        public Criteria andBalacycLessThan(Integer value) {
            addCriterion("BalaCyc <", value, "balacyc");
            return (Criteria) this;
        }

        public Criteria andBalacycLessThanOrEqualTo(Integer value) {
            addCriterion("BalaCyc <=", value, "balacyc");
            return (Criteria) this;
        }

        public Criteria andBalacycIn(List<Integer> values) {
            addCriterion("BalaCyc in", values, "balacyc");
            return (Criteria) this;
        }

        public Criteria andBalacycNotIn(List<Integer> values) {
            addCriterion("BalaCyc not in", values, "balacyc");
            return (Criteria) this;
        }

        public Criteria andBalacycBetween(Integer value1, Integer value2) {
            addCriterion("BalaCyc between", value1, value2, "balacyc");
            return (Criteria) this;
        }

        public Criteria andBalacycNotBetween(Integer value1, Integer value2) {
            addCriterion("BalaCyc not between", value1, value2, "balacyc");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andBalaamtIsNull() {
            addCriterion("BalaAmt is null");
            return (Criteria) this;
        }

        public Criteria andBalaamtIsNotNull() {
            addCriterion("BalaAmt is not null");
            return (Criteria) this;
        }

        public Criteria andBalaamtEqualTo(BigDecimal value) {
            addCriterion("BalaAmt =", value, "balaamt");
            return (Criteria) this;
        }

        public Criteria andBalaamtNotEqualTo(BigDecimal value) {
            addCriterion("BalaAmt <>", value, "balaamt");
            return (Criteria) this;
        }

        public Criteria andBalaamtGreaterThan(BigDecimal value) {
            addCriterion("BalaAmt >", value, "balaamt");
            return (Criteria) this;
        }

        public Criteria andBalaamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaAmt >=", value, "balaamt");
            return (Criteria) this;
        }

        public Criteria andBalaamtLessThan(BigDecimal value) {
            addCriterion("BalaAmt <", value, "balaamt");
            return (Criteria) this;
        }

        public Criteria andBalaamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaAmt <=", value, "balaamt");
            return (Criteria) this;
        }

        public Criteria andBalaamtIn(List<BigDecimal> values) {
            addCriterion("BalaAmt in", values, "balaamt");
            return (Criteria) this;
        }

        public Criteria andBalaamtNotIn(List<BigDecimal> values) {
            addCriterion("BalaAmt not in", values, "balaamt");
            return (Criteria) this;
        }

        public Criteria andBalaamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaAmt between", value1, value2, "balaamt");
            return (Criteria) this;
        }

        public Criteria andBalaamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaAmt not between", value1, value2, "balaamt");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoIsNull() {
            addCriterion("InvoiceBillNo is null");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoIsNotNull() {
            addCriterion("InvoiceBillNo is not null");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoEqualTo(String value) {
            addCriterion("InvoiceBillNo =", value, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoNotEqualTo(String value) {
            addCriterion("InvoiceBillNo <>", value, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoGreaterThan(String value) {
            addCriterion("InvoiceBillNo >", value, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoGreaterThanOrEqualTo(String value) {
            addCriterion("InvoiceBillNo >=", value, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoLessThan(String value) {
            addCriterion("InvoiceBillNo <", value, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoLessThanOrEqualTo(String value) {
            addCriterion("InvoiceBillNo <=", value, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoLike(String value) {
            addCriterion("InvoiceBillNo like", value, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoNotLike(String value) {
            addCriterion("InvoiceBillNo not like", value, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoIn(List<String> values) {
            addCriterion("InvoiceBillNo in", values, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoNotIn(List<String> values) {
            addCriterion("InvoiceBillNo not in", values, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoBetween(String value1, String value2) {
            addCriterion("InvoiceBillNo between", value1, value2, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andInvoicebillnoNotBetween(String value1, String value2) {
            addCriterion("InvoiceBillNo not between", value1, value2, "invoicebillno");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeIsNull() {
            addCriterion("ClientItemCode is null");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeIsNotNull() {
            addCriterion("ClientItemCode is not null");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeEqualTo(String value) {
            addCriterion("ClientItemCode =", value, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeNotEqualTo(String value) {
            addCriterion("ClientItemCode <>", value, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeGreaterThan(String value) {
            addCriterion("ClientItemCode >", value, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ClientItemCode >=", value, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeLessThan(String value) {
            addCriterion("ClientItemCode <", value, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeLessThanOrEqualTo(String value) {
            addCriterion("ClientItemCode <=", value, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeLike(String value) {
            addCriterion("ClientItemCode like", value, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeNotLike(String value) {
            addCriterion("ClientItemCode not like", value, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeIn(List<String> values) {
            addCriterion("ClientItemCode in", values, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeNotIn(List<String> values) {
            addCriterion("ClientItemCode not in", values, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeBetween(String value1, String value2) {
            addCriterion("ClientItemCode between", value1, value2, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andClientitemcodeNotBetween(String value1, String value2) {
            addCriterion("ClientItemCode not between", value1, value2, "clientitemcode");
            return (Criteria) this;
        }

        public Criteria andRetailpriceIsNull() {
            addCriterion("RetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andRetailpriceIsNotNull() {
            addCriterion("RetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRetailpriceEqualTo(BigDecimal value) {
            addCriterion("RetailPrice =", value, "retailprice");
            return (Criteria) this;
        }

        public Criteria andRetailpriceNotEqualTo(BigDecimal value) {
            addCriterion("RetailPrice <>", value, "retailprice");
            return (Criteria) this;
        }

        public Criteria andRetailpriceGreaterThan(BigDecimal value) {
            addCriterion("RetailPrice >", value, "retailprice");
            return (Criteria) this;
        }

        public Criteria andRetailpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RetailPrice >=", value, "retailprice");
            return (Criteria) this;
        }

        public Criteria andRetailpriceLessThan(BigDecimal value) {
            addCriterion("RetailPrice <", value, "retailprice");
            return (Criteria) this;
        }

        public Criteria andRetailpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RetailPrice <=", value, "retailprice");
            return (Criteria) this;
        }

        public Criteria andRetailpriceIn(List<BigDecimal> values) {
            addCriterion("RetailPrice in", values, "retailprice");
            return (Criteria) this;
        }

        public Criteria andRetailpriceNotIn(List<BigDecimal> values) {
            addCriterion("RetailPrice not in", values, "retailprice");
            return (Criteria) this;
        }

        public Criteria andRetailpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RetailPrice between", value1, value2, "retailprice");
            return (Criteria) this;
        }

        public Criteria andRetailpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RetailPrice not between", value1, value2, "retailprice");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceIsNull() {
            addCriterion("RetailNetPrice is null");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceIsNotNull() {
            addCriterion("RetailNetPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceEqualTo(BigDecimal value) {
            addCriterion("RetailNetPrice =", value, "retailnetprice");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceNotEqualTo(BigDecimal value) {
            addCriterion("RetailNetPrice <>", value, "retailnetprice");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceGreaterThan(BigDecimal value) {
            addCriterion("RetailNetPrice >", value, "retailnetprice");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RetailNetPrice >=", value, "retailnetprice");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceLessThan(BigDecimal value) {
            addCriterion("RetailNetPrice <", value, "retailnetprice");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RetailNetPrice <=", value, "retailnetprice");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceIn(List<BigDecimal> values) {
            addCriterion("RetailNetPrice in", values, "retailnetprice");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceNotIn(List<BigDecimal> values) {
            addCriterion("RetailNetPrice not in", values, "retailnetprice");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RetailNetPrice between", value1, value2, "retailnetprice");
            return (Criteria) this;
        }

        public Criteria andRetailnetpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RetailNetPrice not between", value1, value2, "retailnetprice");
            return (Criteria) this;
        }

        public Criteria andRetailamtIsNull() {
            addCriterion("RetailAmt is null");
            return (Criteria) this;
        }

        public Criteria andRetailamtIsNotNull() {
            addCriterion("RetailAmt is not null");
            return (Criteria) this;
        }

        public Criteria andRetailamtEqualTo(BigDecimal value) {
            addCriterion("RetailAmt =", value, "retailamt");
            return (Criteria) this;
        }

        public Criteria andRetailamtNotEqualTo(BigDecimal value) {
            addCriterion("RetailAmt <>", value, "retailamt");
            return (Criteria) this;
        }

        public Criteria andRetailamtGreaterThan(BigDecimal value) {
            addCriterion("RetailAmt >", value, "retailamt");
            return (Criteria) this;
        }

        public Criteria andRetailamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RetailAmt >=", value, "retailamt");
            return (Criteria) this;
        }

        public Criteria andRetailamtLessThan(BigDecimal value) {
            addCriterion("RetailAmt <", value, "retailamt");
            return (Criteria) this;
        }

        public Criteria andRetailamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RetailAmt <=", value, "retailamt");
            return (Criteria) this;
        }

        public Criteria andRetailamtIn(List<BigDecimal> values) {
            addCriterion("RetailAmt in", values, "retailamt");
            return (Criteria) this;
        }

        public Criteria andRetailamtNotIn(List<BigDecimal> values) {
            addCriterion("RetailAmt not in", values, "retailamt");
            return (Criteria) this;
        }

        public Criteria andRetailamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RetailAmt between", value1, value2, "retailamt");
            return (Criteria) this;
        }

        public Criteria andRetailamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RetailAmt not between", value1, value2, "retailamt");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtIsNull() {
            addCriterion("RetailNetAmt is null");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtIsNotNull() {
            addCriterion("RetailNetAmt is not null");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtEqualTo(BigDecimal value) {
            addCriterion("RetailNetAmt =", value, "retailnetamt");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtNotEqualTo(BigDecimal value) {
            addCriterion("RetailNetAmt <>", value, "retailnetamt");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtGreaterThan(BigDecimal value) {
            addCriterion("RetailNetAmt >", value, "retailnetamt");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RetailNetAmt >=", value, "retailnetamt");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtLessThan(BigDecimal value) {
            addCriterion("RetailNetAmt <", value, "retailnetamt");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RetailNetAmt <=", value, "retailnetamt");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtIn(List<BigDecimal> values) {
            addCriterion("RetailNetAmt in", values, "retailnetamt");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtNotIn(List<BigDecimal> values) {
            addCriterion("RetailNetAmt not in", values, "retailnetamt");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RetailNetAmt between", value1, value2, "retailnetamt");
            return (Criteria) this;
        }

        public Criteria andRetailnetamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RetailNetAmt not between", value1, value2, "retailnetamt");
            return (Criteria) this;
        }

        public Criteria andManubillnoIsNull() {
            addCriterion("ManuBillNo is null");
            return (Criteria) this;
        }

        public Criteria andManubillnoIsNotNull() {
            addCriterion("ManuBillNo is not null");
            return (Criteria) this;
        }

        public Criteria andManubillnoEqualTo(String value) {
            addCriterion("ManuBillNo =", value, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoNotEqualTo(String value) {
            addCriterion("ManuBillNo <>", value, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoGreaterThan(String value) {
            addCriterion("ManuBillNo >", value, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoGreaterThanOrEqualTo(String value) {
            addCriterion("ManuBillNo >=", value, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoLessThan(String value) {
            addCriterion("ManuBillNo <", value, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoLessThanOrEqualTo(String value) {
            addCriterion("ManuBillNo <=", value, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoLike(String value) {
            addCriterion("ManuBillNo like", value, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoNotLike(String value) {
            addCriterion("ManuBillNo not like", value, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoIn(List<String> values) {
            addCriterion("ManuBillNo in", values, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoNotIn(List<String> values) {
            addCriterion("ManuBillNo not in", values, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoBetween(String value1, String value2) {
            addCriterion("ManuBillNo between", value1, value2, "manubillno");
            return (Criteria) this;
        }

        public Criteria andManubillnoNotBetween(String value1, String value2) {
            addCriterion("ManuBillNo not between", value1, value2, "manubillno");
            return (Criteria) this;
        }

        public Criteria andInstocktagIsNull() {
            addCriterion("InStockTag is null");
            return (Criteria) this;
        }

        public Criteria andInstocktagIsNotNull() {
            addCriterion("InStockTag is not null");
            return (Criteria) this;
        }

        public Criteria andInstocktagEqualTo(String value) {
            addCriterion("InStockTag =", value, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagNotEqualTo(String value) {
            addCriterion("InStockTag <>", value, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagGreaterThan(String value) {
            addCriterion("InStockTag >", value, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagGreaterThanOrEqualTo(String value) {
            addCriterion("InStockTag >=", value, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagLessThan(String value) {
            addCriterion("InStockTag <", value, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagLessThanOrEqualTo(String value) {
            addCriterion("InStockTag <=", value, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagLike(String value) {
            addCriterion("InStockTag like", value, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagNotLike(String value) {
            addCriterion("InStockTag not like", value, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagIn(List<String> values) {
            addCriterion("InStockTag in", values, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagNotIn(List<String> values) {
            addCriterion("InStockTag not in", values, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagBetween(String value1, String value2) {
            addCriterion("InStockTag between", value1, value2, "instocktag");
            return (Criteria) this;
        }

        public Criteria andInstocktagNotBetween(String value1, String value2) {
            addCriterion("InStockTag not between", value1, value2, "instocktag");
            return (Criteria) this;
        }

        public Criteria andWsalertagIsNull() {
            addCriterion("WsaleRTag is null");
            return (Criteria) this;
        }

        public Criteria andWsalertagIsNotNull() {
            addCriterion("WsaleRTag is not null");
            return (Criteria) this;
        }

        public Criteria andWsalertagEqualTo(String value) {
            addCriterion("WsaleRTag =", value, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagNotEqualTo(String value) {
            addCriterion("WsaleRTag <>", value, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagGreaterThan(String value) {
            addCriterion("WsaleRTag >", value, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagGreaterThanOrEqualTo(String value) {
            addCriterion("WsaleRTag >=", value, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagLessThan(String value) {
            addCriterion("WsaleRTag <", value, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagLessThanOrEqualTo(String value) {
            addCriterion("WsaleRTag <=", value, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagLike(String value) {
            addCriterion("WsaleRTag like", value, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagNotLike(String value) {
            addCriterion("WsaleRTag not like", value, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagIn(List<String> values) {
            addCriterion("WsaleRTag in", values, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagNotIn(List<String> values) {
            addCriterion("WsaleRTag not in", values, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagBetween(String value1, String value2) {
            addCriterion("WsaleRTag between", value1, value2, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andWsalertagNotBetween(String value1, String value2) {
            addCriterion("WsaleRTag not between", value1, value2, "wsalertag");
            return (Criteria) this;
        }

        public Criteria andAutobillnoIsNull() {
            addCriterion("AutoBillNo is null");
            return (Criteria) this;
        }

        public Criteria andAutobillnoIsNotNull() {
            addCriterion("AutoBillNo is not null");
            return (Criteria) this;
        }

        public Criteria andAutobillnoEqualTo(String value) {
            addCriterion("AutoBillNo =", value, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoNotEqualTo(String value) {
            addCriterion("AutoBillNo <>", value, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoGreaterThan(String value) {
            addCriterion("AutoBillNo >", value, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoGreaterThanOrEqualTo(String value) {
            addCriterion("AutoBillNo >=", value, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoLessThan(String value) {
            addCriterion("AutoBillNo <", value, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoLessThanOrEqualTo(String value) {
            addCriterion("AutoBillNo <=", value, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoLike(String value) {
            addCriterion("AutoBillNo like", value, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoNotLike(String value) {
            addCriterion("AutoBillNo not like", value, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoIn(List<String> values) {
            addCriterion("AutoBillNo in", values, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoNotIn(List<String> values) {
            addCriterion("AutoBillNo not in", values, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoBetween(String value1, String value2) {
            addCriterion("AutoBillNo between", value1, value2, "autobillno");
            return (Criteria) this;
        }

        public Criteria andAutobillnoNotBetween(String value1, String value2) {
            addCriterion("AutoBillNo not between", value1, value2, "autobillno");
            return (Criteria) this;
        }

        public Criteria andRelatenoIsNull() {
            addCriterion("RelateNo is null");
            return (Criteria) this;
        }

        public Criteria andRelatenoIsNotNull() {
            addCriterion("RelateNo is not null");
            return (Criteria) this;
        }

        public Criteria andRelatenoEqualTo(String value) {
            addCriterion("RelateNo =", value, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoNotEqualTo(String value) {
            addCriterion("RelateNo <>", value, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoGreaterThan(String value) {
            addCriterion("RelateNo >", value, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoGreaterThanOrEqualTo(String value) {
            addCriterion("RelateNo >=", value, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoLessThan(String value) {
            addCriterion("RelateNo <", value, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoLessThanOrEqualTo(String value) {
            addCriterion("RelateNo <=", value, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoLike(String value) {
            addCriterion("RelateNo like", value, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoNotLike(String value) {
            addCriterion("RelateNo not like", value, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoIn(List<String> values) {
            addCriterion("RelateNo in", values, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoNotIn(List<String> values) {
            addCriterion("RelateNo not in", values, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoBetween(String value1, String value2) {
            addCriterion("RelateNo between", value1, value2, "relateno");
            return (Criteria) this;
        }

        public Criteria andRelatenoNotBetween(String value1, String value2) {
            addCriterion("RelateNo not between", value1, value2, "relateno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoIsNull() {
            addCriterion("PickSupNo is null");
            return (Criteria) this;
        }

        public Criteria andPicksupnoIsNotNull() {
            addCriterion("PickSupNo is not null");
            return (Criteria) this;
        }

        public Criteria andPicksupnoEqualTo(String value) {
            addCriterion("PickSupNo =", value, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoNotEqualTo(String value) {
            addCriterion("PickSupNo <>", value, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoGreaterThan(String value) {
            addCriterion("PickSupNo >", value, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoGreaterThanOrEqualTo(String value) {
            addCriterion("PickSupNo >=", value, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoLessThan(String value) {
            addCriterion("PickSupNo <", value, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoLessThanOrEqualTo(String value) {
            addCriterion("PickSupNo <=", value, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoLike(String value) {
            addCriterion("PickSupNo like", value, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoNotLike(String value) {
            addCriterion("PickSupNo not like", value, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoIn(List<String> values) {
            addCriterion("PickSupNo in", values, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoNotIn(List<String> values) {
            addCriterion("PickSupNo not in", values, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoBetween(String value1, String value2) {
            addCriterion("PickSupNo between", value1, value2, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksupnoNotBetween(String value1, String value2) {
            addCriterion("PickSupNo not between", value1, value2, "picksupno");
            return (Criteria) this;
        }

        public Criteria andPicksuptagIsNull() {
            addCriterion("PickSupTag is null");
            return (Criteria) this;
        }

        public Criteria andPicksuptagIsNotNull() {
            addCriterion("PickSupTag is not null");
            return (Criteria) this;
        }

        public Criteria andPicksuptagEqualTo(String value) {
            addCriterion("PickSupTag =", value, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagNotEqualTo(String value) {
            addCriterion("PickSupTag <>", value, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagGreaterThan(String value) {
            addCriterion("PickSupTag >", value, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagGreaterThanOrEqualTo(String value) {
            addCriterion("PickSupTag >=", value, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagLessThan(String value) {
            addCriterion("PickSupTag <", value, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagLessThanOrEqualTo(String value) {
            addCriterion("PickSupTag <=", value, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagLike(String value) {
            addCriterion("PickSupTag like", value, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagNotLike(String value) {
            addCriterion("PickSupTag not like", value, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagIn(List<String> values) {
            addCriterion("PickSupTag in", values, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagNotIn(List<String> values) {
            addCriterion("PickSupTag not in", values, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagBetween(String value1, String value2) {
            addCriterion("PickSupTag between", value1, value2, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andPicksuptagNotBetween(String value1, String value2) {
            addCriterion("PickSupTag not between", value1, value2, "picksuptag");
            return (Criteria) this;
        }

        public Criteria andNewbaladateIsNull() {
            addCriterion("NewBalaDate is null");
            return (Criteria) this;
        }

        public Criteria andNewbaladateIsNotNull() {
            addCriterion("NewBalaDate is not null");
            return (Criteria) this;
        }

        public Criteria andNewbaladateEqualTo(Date value) {
            addCriterion("NewBalaDate =", value, "newbaladate");
            return (Criteria) this;
        }

        public Criteria andNewbaladateNotEqualTo(Date value) {
            addCriterion("NewBalaDate <>", value, "newbaladate");
            return (Criteria) this;
        }

        public Criteria andNewbaladateGreaterThan(Date value) {
            addCriterion("NewBalaDate >", value, "newbaladate");
            return (Criteria) this;
        }

        public Criteria andNewbaladateGreaterThanOrEqualTo(Date value) {
            addCriterion("NewBalaDate >=", value, "newbaladate");
            return (Criteria) this;
        }

        public Criteria andNewbaladateLessThan(Date value) {
            addCriterion("NewBalaDate <", value, "newbaladate");
            return (Criteria) this;
        }

        public Criteria andNewbaladateLessThanOrEqualTo(Date value) {
            addCriterion("NewBalaDate <=", value, "newbaladate");
            return (Criteria) this;
        }

        public Criteria andNewbaladateIn(List<Date> values) {
            addCriterion("NewBalaDate in", values, "newbaladate");
            return (Criteria) this;
        }

        public Criteria andNewbaladateNotIn(List<Date> values) {
            addCriterion("NewBalaDate not in", values, "newbaladate");
            return (Criteria) this;
        }

        public Criteria andNewbaladateBetween(Date value1, Date value2) {
            addCriterion("NewBalaDate between", value1, value2, "newbaladate");
            return (Criteria) this;
        }

        public Criteria andNewbaladateNotBetween(Date value1, Date value2) {
            addCriterion("NewBalaDate not between", value1, value2, "newbaladate");
            return (Criteria) this;
        }

        public Criteria andRealcostIsNull() {
            addCriterion("RealCost is null");
            return (Criteria) this;
        }

        public Criteria andRealcostIsNotNull() {
            addCriterion("RealCost is not null");
            return (Criteria) this;
        }

        public Criteria andRealcostEqualTo(BigDecimal value) {
            addCriterion("RealCost =", value, "realcost");
            return (Criteria) this;
        }

        public Criteria andRealcostNotEqualTo(BigDecimal value) {
            addCriterion("RealCost <>", value, "realcost");
            return (Criteria) this;
        }

        public Criteria andRealcostGreaterThan(BigDecimal value) {
            addCriterion("RealCost >", value, "realcost");
            return (Criteria) this;
        }

        public Criteria andRealcostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RealCost >=", value, "realcost");
            return (Criteria) this;
        }

        public Criteria andRealcostLessThan(BigDecimal value) {
            addCriterion("RealCost <", value, "realcost");
            return (Criteria) this;
        }

        public Criteria andRealcostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RealCost <=", value, "realcost");
            return (Criteria) this;
        }

        public Criteria andRealcostIn(List<BigDecimal> values) {
            addCriterion("RealCost in", values, "realcost");
            return (Criteria) this;
        }

        public Criteria andRealcostNotIn(List<BigDecimal> values) {
            addCriterion("RealCost not in", values, "realcost");
            return (Criteria) this;
        }

        public Criteria andRealcostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RealCost between", value1, value2, "realcost");
            return (Criteria) this;
        }

        public Criteria andRealcostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RealCost not between", value1, value2, "realcost");
            return (Criteria) this;
        }

        public Criteria andRealnetcostIsNull() {
            addCriterion("RealNetCost is null");
            return (Criteria) this;
        }

        public Criteria andRealnetcostIsNotNull() {
            addCriterion("RealNetCost is not null");
            return (Criteria) this;
        }

        public Criteria andRealnetcostEqualTo(BigDecimal value) {
            addCriterion("RealNetCost =", value, "realnetcost");
            return (Criteria) this;
        }

        public Criteria andRealnetcostNotEqualTo(BigDecimal value) {
            addCriterion("RealNetCost <>", value, "realnetcost");
            return (Criteria) this;
        }

        public Criteria andRealnetcostGreaterThan(BigDecimal value) {
            addCriterion("RealNetCost >", value, "realnetcost");
            return (Criteria) this;
        }

        public Criteria andRealnetcostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RealNetCost >=", value, "realnetcost");
            return (Criteria) this;
        }

        public Criteria andRealnetcostLessThan(BigDecimal value) {
            addCriterion("RealNetCost <", value, "realnetcost");
            return (Criteria) this;
        }

        public Criteria andRealnetcostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RealNetCost <=", value, "realnetcost");
            return (Criteria) this;
        }

        public Criteria andRealnetcostIn(List<BigDecimal> values) {
            addCriterion("RealNetCost in", values, "realnetcost");
            return (Criteria) this;
        }

        public Criteria andRealnetcostNotIn(List<BigDecimal> values) {
            addCriterion("RealNetCost not in", values, "realnetcost");
            return (Criteria) this;
        }

        public Criteria andRealnetcostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RealNetCost between", value1, value2, "realnetcost");
            return (Criteria) this;
        }

        public Criteria andRealnetcostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RealNetCost not between", value1, value2, "realnetcost");
            return (Criteria) this;
        }

        public Criteria andCheckqtyIsNull() {
            addCriterion("CheckQty is null");
            return (Criteria) this;
        }

        public Criteria andCheckqtyIsNotNull() {
            addCriterion("CheckQty is not null");
            return (Criteria) this;
        }

        public Criteria andCheckqtyEqualTo(BigDecimal value) {
            addCriterion("CheckQty =", value, "checkqty");
            return (Criteria) this;
        }

        public Criteria andCheckqtyNotEqualTo(BigDecimal value) {
            addCriterion("CheckQty <>", value, "checkqty");
            return (Criteria) this;
        }

        public Criteria andCheckqtyGreaterThan(BigDecimal value) {
            addCriterion("CheckQty >", value, "checkqty");
            return (Criteria) this;
        }

        public Criteria andCheckqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CheckQty >=", value, "checkqty");
            return (Criteria) this;
        }

        public Criteria andCheckqtyLessThan(BigDecimal value) {
            addCriterion("CheckQty <", value, "checkqty");
            return (Criteria) this;
        }

        public Criteria andCheckqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CheckQty <=", value, "checkqty");
            return (Criteria) this;
        }

        public Criteria andCheckqtyIn(List<BigDecimal> values) {
            addCriterion("CheckQty in", values, "checkqty");
            return (Criteria) this;
        }

        public Criteria andCheckqtyNotIn(List<BigDecimal> values) {
            addCriterion("CheckQty not in", values, "checkqty");
            return (Criteria) this;
        }

        public Criteria andCheckqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CheckQty between", value1, value2, "checkqty");
            return (Criteria) this;
        }

        public Criteria andCheckqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CheckQty not between", value1, value2, "checkqty");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagIsNull() {
            addCriterion("PriceApproveTag is null");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagIsNotNull() {
            addCriterion("PriceApproveTag is not null");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagEqualTo(String value) {
            addCriterion("PriceApproveTag =", value, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagNotEqualTo(String value) {
            addCriterion("PriceApproveTag <>", value, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagGreaterThan(String value) {
            addCriterion("PriceApproveTag >", value, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagGreaterThanOrEqualTo(String value) {
            addCriterion("PriceApproveTag >=", value, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagLessThan(String value) {
            addCriterion("PriceApproveTag <", value, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagLessThanOrEqualTo(String value) {
            addCriterion("PriceApproveTag <=", value, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagLike(String value) {
            addCriterion("PriceApproveTag like", value, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagNotLike(String value) {
            addCriterion("PriceApproveTag not like", value, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagIn(List<String> values) {
            addCriterion("PriceApproveTag in", values, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagNotIn(List<String> values) {
            addCriterion("PriceApproveTag not in", values, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagBetween(String value1, String value2) {
            addCriterion("PriceApproveTag between", value1, value2, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andPriceapprovetagNotBetween(String value1, String value2) {
            addCriterion("PriceApproveTag not between", value1, value2, "priceapprovetag");
            return (Criteria) this;
        }

        public Criteria andOutcontractIsNull() {
            addCriterion("OutContract is null");
            return (Criteria) this;
        }

        public Criteria andOutcontractIsNotNull() {
            addCriterion("OutContract is not null");
            return (Criteria) this;
        }

        public Criteria andOutcontractEqualTo(String value) {
            addCriterion("OutContract =", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractNotEqualTo(String value) {
            addCriterion("OutContract <>", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractGreaterThan(String value) {
            addCriterion("OutContract >", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractGreaterThanOrEqualTo(String value) {
            addCriterion("OutContract >=", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractLessThan(String value) {
            addCriterion("OutContract <", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractLessThanOrEqualTo(String value) {
            addCriterion("OutContract <=", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractLike(String value) {
            addCriterion("OutContract like", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractNotLike(String value) {
            addCriterion("OutContract not like", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractIn(List<String> values) {
            addCriterion("OutContract in", values, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractNotIn(List<String> values) {
            addCriterion("OutContract not in", values, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractBetween(String value1, String value2) {
            addCriterion("OutContract between", value1, value2, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractNotBetween(String value1, String value2) {
            addCriterion("OutContract not between", value1, value2, "outcontract");
            return (Criteria) this;
        }

        public Criteria andWeightIsNull() {
            addCriterion("Weight is null");
            return (Criteria) this;
        }

        public Criteria andWeightIsNotNull() {
            addCriterion("Weight is not null");
            return (Criteria) this;
        }

        public Criteria andWeightEqualTo(BigDecimal value) {
            addCriterion("Weight =", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotEqualTo(BigDecimal value) {
            addCriterion("Weight <>", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThan(BigDecimal value) {
            addCriterion("Weight >", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Weight >=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThan(BigDecimal value) {
            addCriterion("Weight <", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Weight <=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightIn(List<BigDecimal> values) {
            addCriterion("Weight in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotIn(List<BigDecimal> values) {
            addCriterion("Weight not in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Weight between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Weight not between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andVolumeIsNull() {
            addCriterion("Volume is null");
            return (Criteria) this;
        }

        public Criteria andVolumeIsNotNull() {
            addCriterion("Volume is not null");
            return (Criteria) this;
        }

        public Criteria andVolumeEqualTo(BigDecimal value) {
            addCriterion("Volume =", value, "volume");
            return (Criteria) this;
        }

        public Criteria andVolumeNotEqualTo(BigDecimal value) {
            addCriterion("Volume <>", value, "volume");
            return (Criteria) this;
        }

        public Criteria andVolumeGreaterThan(BigDecimal value) {
            addCriterion("Volume >", value, "volume");
            return (Criteria) this;
        }

        public Criteria andVolumeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Volume >=", value, "volume");
            return (Criteria) this;
        }

        public Criteria andVolumeLessThan(BigDecimal value) {
            addCriterion("Volume <", value, "volume");
            return (Criteria) this;
        }

        public Criteria andVolumeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Volume <=", value, "volume");
            return (Criteria) this;
        }

        public Criteria andVolumeIn(List<BigDecimal> values) {
            addCriterion("Volume in", values, "volume");
            return (Criteria) this;
        }

        public Criteria andVolumeNotIn(List<BigDecimal> values) {
            addCriterion("Volume not in", values, "volume");
            return (Criteria) this;
        }

        public Criteria andVolumeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Volume between", value1, value2, "volume");
            return (Criteria) this;
        }

        public Criteria andVolumeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Volume not between", value1, value2, "volume");
            return (Criteria) this;
        }

        public Criteria andTransreturndateIsNull() {
            addCriterion("TransReturnDate is null");
            return (Criteria) this;
        }

        public Criteria andTransreturndateIsNotNull() {
            addCriterion("TransReturnDate is not null");
            return (Criteria) this;
        }

        public Criteria andTransreturndateEqualTo(Date value) {
            addCriterion("TransReturnDate =", value, "transreturndate");
            return (Criteria) this;
        }

        public Criteria andTransreturndateNotEqualTo(Date value) {
            addCriterion("TransReturnDate <>", value, "transreturndate");
            return (Criteria) this;
        }

        public Criteria andTransreturndateGreaterThan(Date value) {
            addCriterion("TransReturnDate >", value, "transreturndate");
            return (Criteria) this;
        }

        public Criteria andTransreturndateGreaterThanOrEqualTo(Date value) {
            addCriterion("TransReturnDate >=", value, "transreturndate");
            return (Criteria) this;
        }

        public Criteria andTransreturndateLessThan(Date value) {
            addCriterion("TransReturnDate <", value, "transreturndate");
            return (Criteria) this;
        }

        public Criteria andTransreturndateLessThanOrEqualTo(Date value) {
            addCriterion("TransReturnDate <=", value, "transreturndate");
            return (Criteria) this;
        }

        public Criteria andTransreturndateIn(List<Date> values) {
            addCriterion("TransReturnDate in", values, "transreturndate");
            return (Criteria) this;
        }

        public Criteria andTransreturndateNotIn(List<Date> values) {
            addCriterion("TransReturnDate not in", values, "transreturndate");
            return (Criteria) this;
        }

        public Criteria andTransreturndateBetween(Date value1, Date value2) {
            addCriterion("TransReturnDate between", value1, value2, "transreturndate");
            return (Criteria) this;
        }

        public Criteria andTransreturndateNotBetween(Date value1, Date value2) {
            addCriterion("TransReturnDate not between", value1, value2, "transreturndate");
            return (Criteria) this;
        }

        public Criteria andRvolumeIsNull() {
            addCriterion("RVolume is null");
            return (Criteria) this;
        }

        public Criteria andRvolumeIsNotNull() {
            addCriterion("RVolume is not null");
            return (Criteria) this;
        }

        public Criteria andRvolumeEqualTo(BigDecimal value) {
            addCriterion("RVolume =", value, "rvolume");
            return (Criteria) this;
        }

        public Criteria andRvolumeNotEqualTo(BigDecimal value) {
            addCriterion("RVolume <>", value, "rvolume");
            return (Criteria) this;
        }

        public Criteria andRvolumeGreaterThan(BigDecimal value) {
            addCriterion("RVolume >", value, "rvolume");
            return (Criteria) this;
        }

        public Criteria andRvolumeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RVolume >=", value, "rvolume");
            return (Criteria) this;
        }

        public Criteria andRvolumeLessThan(BigDecimal value) {
            addCriterion("RVolume <", value, "rvolume");
            return (Criteria) this;
        }

        public Criteria andRvolumeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RVolume <=", value, "rvolume");
            return (Criteria) this;
        }

        public Criteria andRvolumeIn(List<BigDecimal> values) {
            addCriterion("RVolume in", values, "rvolume");
            return (Criteria) this;
        }

        public Criteria andRvolumeNotIn(List<BigDecimal> values) {
            addCriterion("RVolume not in", values, "rvolume");
            return (Criteria) this;
        }

        public Criteria andRvolumeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RVolume between", value1, value2, "rvolume");
            return (Criteria) this;
        }

        public Criteria andRvolumeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RVolume not between", value1, value2, "rvolume");
            return (Criteria) this;
        }

        public Criteria andPromrulesIsNull() {
            addCriterion("PromRules is null");
            return (Criteria) this;
        }

        public Criteria andPromrulesIsNotNull() {
            addCriterion("PromRules is not null");
            return (Criteria) this;
        }

        public Criteria andPromrulesEqualTo(String value) {
            addCriterion("PromRules =", value, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesNotEqualTo(String value) {
            addCriterion("PromRules <>", value, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesGreaterThan(String value) {
            addCriterion("PromRules >", value, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesGreaterThanOrEqualTo(String value) {
            addCriterion("PromRules >=", value, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesLessThan(String value) {
            addCriterion("PromRules <", value, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesLessThanOrEqualTo(String value) {
            addCriterion("PromRules <=", value, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesLike(String value) {
            addCriterion("PromRules like", value, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesNotLike(String value) {
            addCriterion("PromRules not like", value, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesIn(List<String> values) {
            addCriterion("PromRules in", values, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesNotIn(List<String> values) {
            addCriterion("PromRules not in", values, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesBetween(String value1, String value2) {
            addCriterion("PromRules between", value1, value2, "promrules");
            return (Criteria) this;
        }

        public Criteria andPromrulesNotBetween(String value1, String value2) {
            addCriterion("PromRules not between", value1, value2, "promrules");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagIsNull() {
            addCriterion("JoinAmtPromTag is null");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagIsNotNull() {
            addCriterion("JoinAmtPromTag is not null");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagEqualTo(String value) {
            addCriterion("JoinAmtPromTag =", value, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagNotEqualTo(String value) {
            addCriterion("JoinAmtPromTag <>", value, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagGreaterThan(String value) {
            addCriterion("JoinAmtPromTag >", value, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagGreaterThanOrEqualTo(String value) {
            addCriterion("JoinAmtPromTag >=", value, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagLessThan(String value) {
            addCriterion("JoinAmtPromTag <", value, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagLessThanOrEqualTo(String value) {
            addCriterion("JoinAmtPromTag <=", value, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagLike(String value) {
            addCriterion("JoinAmtPromTag like", value, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagNotLike(String value) {
            addCriterion("JoinAmtPromTag not like", value, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagIn(List<String> values) {
            addCriterion("JoinAmtPromTag in", values, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagNotIn(List<String> values) {
            addCriterion("JoinAmtPromTag not in", values, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagBetween(String value1, String value2) {
            addCriterion("JoinAmtPromTag between", value1, value2, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andJoinamtpromtagNotBetween(String value1, String value2) {
            addCriterion("JoinAmtPromTag not between", value1, value2, "joinamtpromtag");
            return (Criteria) this;
        }

        public Criteria andDiscountamtIsNull() {
            addCriterion("DiscountAmt is null");
            return (Criteria) this;
        }

        public Criteria andDiscountamtIsNotNull() {
            addCriterion("DiscountAmt is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountamtEqualTo(BigDecimal value) {
            addCriterion("DiscountAmt =", value, "discountamt");
            return (Criteria) this;
        }

        public Criteria andDiscountamtNotEqualTo(BigDecimal value) {
            addCriterion("DiscountAmt <>", value, "discountamt");
            return (Criteria) this;
        }

        public Criteria andDiscountamtGreaterThan(BigDecimal value) {
            addCriterion("DiscountAmt >", value, "discountamt");
            return (Criteria) this;
        }

        public Criteria andDiscountamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DiscountAmt >=", value, "discountamt");
            return (Criteria) this;
        }

        public Criteria andDiscountamtLessThan(BigDecimal value) {
            addCriterion("DiscountAmt <", value, "discountamt");
            return (Criteria) this;
        }

        public Criteria andDiscountamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DiscountAmt <=", value, "discountamt");
            return (Criteria) this;
        }

        public Criteria andDiscountamtIn(List<BigDecimal> values) {
            addCriterion("DiscountAmt in", values, "discountamt");
            return (Criteria) this;
        }

        public Criteria andDiscountamtNotIn(List<BigDecimal> values) {
            addCriterion("DiscountAmt not in", values, "discountamt");
            return (Criteria) this;
        }

        public Criteria andDiscountamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DiscountAmt between", value1, value2, "discountamt");
            return (Criteria) this;
        }

        public Criteria andDiscountamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DiscountAmt not between", value1, value2, "discountamt");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoIsNull() {
            addCriterion("TOrderBillNo is null");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoIsNotNull() {
            addCriterion("TOrderBillNo is not null");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoEqualTo(String value) {
            addCriterion("TOrderBillNo =", value, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoNotEqualTo(String value) {
            addCriterion("TOrderBillNo <>", value, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoGreaterThan(String value) {
            addCriterion("TOrderBillNo >", value, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoGreaterThanOrEqualTo(String value) {
            addCriterion("TOrderBillNo >=", value, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoLessThan(String value) {
            addCriterion("TOrderBillNo <", value, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoLessThanOrEqualTo(String value) {
            addCriterion("TOrderBillNo <=", value, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoLike(String value) {
            addCriterion("TOrderBillNo like", value, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoNotLike(String value) {
            addCriterion("TOrderBillNo not like", value, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoIn(List<String> values) {
            addCriterion("TOrderBillNo in", values, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoNotIn(List<String> values) {
            addCriterion("TOrderBillNo not in", values, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoBetween(String value1, String value2) {
            addCriterion("TOrderBillNo between", value1, value2, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andTorderbillnoNotBetween(String value1, String value2) {
            addCriterion("TOrderBillNo not between", value1, value2, "torderbillno");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyIsNull() {
            addCriterion("DistBackQty is null");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyIsNotNull() {
            addCriterion("DistBackQty is not null");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyEqualTo(BigDecimal value) {
            addCriterion("DistBackQty =", value, "distbackqty");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyNotEqualTo(BigDecimal value) {
            addCriterion("DistBackQty <>", value, "distbackqty");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyGreaterThan(BigDecimal value) {
            addCriterion("DistBackQty >", value, "distbackqty");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DistBackQty >=", value, "distbackqty");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyLessThan(BigDecimal value) {
            addCriterion("DistBackQty <", value, "distbackqty");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DistBackQty <=", value, "distbackqty");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyIn(List<BigDecimal> values) {
            addCriterion("DistBackQty in", values, "distbackqty");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyNotIn(List<BigDecimal> values) {
            addCriterion("DistBackQty not in", values, "distbackqty");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DistBackQty between", value1, value2, "distbackqty");
            return (Criteria) this;
        }

        public Criteria andDistbackqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DistBackQty not between", value1, value2, "distbackqty");
            return (Criteria) this;
        }

        public Criteria andOldestyieldIsNull() {
            addCriterion("OldestYield is null");
            return (Criteria) this;
        }

        public Criteria andOldestyieldIsNotNull() {
            addCriterion("OldestYield is not null");
            return (Criteria) this;
        }

        public Criteria andOldestyieldEqualTo(Date value) {
            addCriterion("OldestYield =", value, "oldestyield");
            return (Criteria) this;
        }

        public Criteria andOldestyieldNotEqualTo(Date value) {
            addCriterion("OldestYield <>", value, "oldestyield");
            return (Criteria) this;
        }

        public Criteria andOldestyieldGreaterThan(Date value) {
            addCriterion("OldestYield >", value, "oldestyield");
            return (Criteria) this;
        }

        public Criteria andOldestyieldGreaterThanOrEqualTo(Date value) {
            addCriterion("OldestYield >=", value, "oldestyield");
            return (Criteria) this;
        }

        public Criteria andOldestyieldLessThan(Date value) {
            addCriterion("OldestYield <", value, "oldestyield");
            return (Criteria) this;
        }

        public Criteria andOldestyieldLessThanOrEqualTo(Date value) {
            addCriterion("OldestYield <=", value, "oldestyield");
            return (Criteria) this;
        }

        public Criteria andOldestyieldIn(List<Date> values) {
            addCriterion("OldestYield in", values, "oldestyield");
            return (Criteria) this;
        }

        public Criteria andOldestyieldNotIn(List<Date> values) {
            addCriterion("OldestYield not in", values, "oldestyield");
            return (Criteria) this;
        }

        public Criteria andOldestyieldBetween(Date value1, Date value2) {
            addCriterion("OldestYield between", value1, value2, "oldestyield");
            return (Criteria) this;
        }

        public Criteria andOldestyieldNotBetween(Date value1, Date value2) {
            addCriterion("OldestYield not between", value1, value2, "oldestyield");
            return (Criteria) this;
        }

        public Criteria andSaleqtysIsNull() {
            addCriterion("SaleQtyS is null");
            return (Criteria) this;
        }

        public Criteria andSaleqtysIsNotNull() {
            addCriterion("SaleQtyS is not null");
            return (Criteria) this;
        }

        public Criteria andSaleqtysEqualTo(BigDecimal value) {
            addCriterion("SaleQtyS =", value, "saleqtys");
            return (Criteria) this;
        }

        public Criteria andSaleqtysNotEqualTo(BigDecimal value) {
            addCriterion("SaleQtyS <>", value, "saleqtys");
            return (Criteria) this;
        }

        public Criteria andSaleqtysGreaterThan(BigDecimal value) {
            addCriterion("SaleQtyS >", value, "saleqtys");
            return (Criteria) this;
        }

        public Criteria andSaleqtysGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleQtyS >=", value, "saleqtys");
            return (Criteria) this;
        }

        public Criteria andSaleqtysLessThan(BigDecimal value) {
            addCriterion("SaleQtyS <", value, "saleqtys");
            return (Criteria) this;
        }

        public Criteria andSaleqtysLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleQtyS <=", value, "saleqtys");
            return (Criteria) this;
        }

        public Criteria andSaleqtysIn(List<BigDecimal> values) {
            addCriterion("SaleQtyS in", values, "saleqtys");
            return (Criteria) this;
        }

        public Criteria andSaleqtysNotIn(List<BigDecimal> values) {
            addCriterion("SaleQtyS not in", values, "saleqtys");
            return (Criteria) this;
        }

        public Criteria andSaleqtysBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleQtyS between", value1, value2, "saleqtys");
            return (Criteria) this;
        }

        public Criteria andSaleqtysNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleQtyS not between", value1, value2, "saleqtys");
            return (Criteria) this;
        }

        public Criteria andSaleqtypIsNull() {
            addCriterion("SaleQtyP is null");
            return (Criteria) this;
        }

        public Criteria andSaleqtypIsNotNull() {
            addCriterion("SaleQtyP is not null");
            return (Criteria) this;
        }

        public Criteria andSaleqtypEqualTo(BigDecimal value) {
            addCriterion("SaleQtyP =", value, "saleqtyp");
            return (Criteria) this;
        }

        public Criteria andSaleqtypNotEqualTo(BigDecimal value) {
            addCriterion("SaleQtyP <>", value, "saleqtyp");
            return (Criteria) this;
        }

        public Criteria andSaleqtypGreaterThan(BigDecimal value) {
            addCriterion("SaleQtyP >", value, "saleqtyp");
            return (Criteria) this;
        }

        public Criteria andSaleqtypGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleQtyP >=", value, "saleqtyp");
            return (Criteria) this;
        }

        public Criteria andSaleqtypLessThan(BigDecimal value) {
            addCriterion("SaleQtyP <", value, "saleqtyp");
            return (Criteria) this;
        }

        public Criteria andSaleqtypLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleQtyP <=", value, "saleqtyp");
            return (Criteria) this;
        }

        public Criteria andSaleqtypIn(List<BigDecimal> values) {
            addCriterion("SaleQtyP in", values, "saleqtyp");
            return (Criteria) this;
        }

        public Criteria andSaleqtypNotIn(List<BigDecimal> values) {
            addCriterion("SaleQtyP not in", values, "saleqtyp");
            return (Criteria) this;
        }

        public Criteria andSaleqtypBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleQtyP between", value1, value2, "saleqtyp");
            return (Criteria) this;
        }

        public Criteria andSaleqtypNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleQtyP not between", value1, value2, "saleqtyp");
            return (Criteria) this;
        }

        public Criteria andSalegqtysIsNull() {
            addCriterion("SaleGQtyS is null");
            return (Criteria) this;
        }

        public Criteria andSalegqtysIsNotNull() {
            addCriterion("SaleGQtyS is not null");
            return (Criteria) this;
        }

        public Criteria andSalegqtysEqualTo(BigDecimal value) {
            addCriterion("SaleGQtyS =", value, "salegqtys");
            return (Criteria) this;
        }

        public Criteria andSalegqtysNotEqualTo(BigDecimal value) {
            addCriterion("SaleGQtyS <>", value, "salegqtys");
            return (Criteria) this;
        }

        public Criteria andSalegqtysGreaterThan(BigDecimal value) {
            addCriterion("SaleGQtyS >", value, "salegqtys");
            return (Criteria) this;
        }

        public Criteria andSalegqtysGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleGQtyS >=", value, "salegqtys");
            return (Criteria) this;
        }

        public Criteria andSalegqtysLessThan(BigDecimal value) {
            addCriterion("SaleGQtyS <", value, "salegqtys");
            return (Criteria) this;
        }

        public Criteria andSalegqtysLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleGQtyS <=", value, "salegqtys");
            return (Criteria) this;
        }

        public Criteria andSalegqtysIn(List<BigDecimal> values) {
            addCriterion("SaleGQtyS in", values, "salegqtys");
            return (Criteria) this;
        }

        public Criteria andSalegqtysNotIn(List<BigDecimal> values) {
            addCriterion("SaleGQtyS not in", values, "salegqtys");
            return (Criteria) this;
        }

        public Criteria andSalegqtysBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleGQtyS between", value1, value2, "salegqtys");
            return (Criteria) this;
        }

        public Criteria andSalegqtysNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleGQtyS not between", value1, value2, "salegqtys");
            return (Criteria) this;
        }

        public Criteria andSalegqtypIsNull() {
            addCriterion("SaleGQtyP is null");
            return (Criteria) this;
        }

        public Criteria andSalegqtypIsNotNull() {
            addCriterion("SaleGQtyP is not null");
            return (Criteria) this;
        }

        public Criteria andSalegqtypEqualTo(BigDecimal value) {
            addCriterion("SaleGQtyP =", value, "salegqtyp");
            return (Criteria) this;
        }

        public Criteria andSalegqtypNotEqualTo(BigDecimal value) {
            addCriterion("SaleGQtyP <>", value, "salegqtyp");
            return (Criteria) this;
        }

        public Criteria andSalegqtypGreaterThan(BigDecimal value) {
            addCriterion("SaleGQtyP >", value, "salegqtyp");
            return (Criteria) this;
        }

        public Criteria andSalegqtypGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleGQtyP >=", value, "salegqtyp");
            return (Criteria) this;
        }

        public Criteria andSalegqtypLessThan(BigDecimal value) {
            addCriterion("SaleGQtyP <", value, "salegqtyp");
            return (Criteria) this;
        }

        public Criteria andSalegqtypLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SaleGQtyP <=", value, "salegqtyp");
            return (Criteria) this;
        }

        public Criteria andSalegqtypIn(List<BigDecimal> values) {
            addCriterion("SaleGQtyP in", values, "salegqtyp");
            return (Criteria) this;
        }

        public Criteria andSalegqtypNotIn(List<BigDecimal> values) {
            addCriterion("SaleGQtyP not in", values, "salegqtyp");
            return (Criteria) this;
        }

        public Criteria andSalegqtypBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleGQtyP between", value1, value2, "salegqtyp");
            return (Criteria) this;
        }

        public Criteria andSalegqtypNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SaleGQtyP not between", value1, value2, "salegqtyp");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeIsNull() {
            addCriterion("Profit2DistFee is null");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeIsNotNull() {
            addCriterion("Profit2DistFee is not null");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeEqualTo(BigDecimal value) {
            addCriterion("Profit2DistFee =", value, "profit2distfee");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeNotEqualTo(BigDecimal value) {
            addCriterion("Profit2DistFee <>", value, "profit2distfee");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeGreaterThan(BigDecimal value) {
            addCriterion("Profit2DistFee >", value, "profit2distfee");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Profit2DistFee >=", value, "profit2distfee");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeLessThan(BigDecimal value) {
            addCriterion("Profit2DistFee <", value, "profit2distfee");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Profit2DistFee <=", value, "profit2distfee");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeIn(List<BigDecimal> values) {
            addCriterion("Profit2DistFee in", values, "profit2distfee");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeNotIn(List<BigDecimal> values) {
            addCriterion("Profit2DistFee not in", values, "profit2distfee");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Profit2DistFee between", value1, value2, "profit2distfee");
            return (Criteria) this;
        }

        public Criteria andProfit2distfeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Profit2DistFee not between", value1, value2, "profit2distfee");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeIsNull() {
            addCriterion("VendorDistFee is null");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeIsNotNull() {
            addCriterion("VendorDistFee is not null");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeEqualTo(BigDecimal value) {
            addCriterion("VendorDistFee =", value, "vendordistfee");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeNotEqualTo(BigDecimal value) {
            addCriterion("VendorDistFee <>", value, "vendordistfee");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeGreaterThan(BigDecimal value) {
            addCriterion("VendorDistFee >", value, "vendordistfee");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VendorDistFee >=", value, "vendordistfee");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeLessThan(BigDecimal value) {
            addCriterion("VendorDistFee <", value, "vendordistfee");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VendorDistFee <=", value, "vendordistfee");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeIn(List<BigDecimal> values) {
            addCriterion("VendorDistFee in", values, "vendordistfee");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeNotIn(List<BigDecimal> values) {
            addCriterion("VendorDistFee not in", values, "vendordistfee");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VendorDistFee between", value1, value2, "vendordistfee");
            return (Criteria) this;
        }

        public Criteria andVendordistfeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VendorDistFee not between", value1, value2, "vendordistfee");
            return (Criteria) this;
        }

        public Criteria andVipcashtagIsNull() {
            addCriterion("VipCashTag is null");
            return (Criteria) this;
        }

        public Criteria andVipcashtagIsNotNull() {
            addCriterion("VipCashTag is not null");
            return (Criteria) this;
        }

        public Criteria andVipcashtagEqualTo(String value) {
            addCriterion("VipCashTag =", value, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagNotEqualTo(String value) {
            addCriterion("VipCashTag <>", value, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagGreaterThan(String value) {
            addCriterion("VipCashTag >", value, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagGreaterThanOrEqualTo(String value) {
            addCriterion("VipCashTag >=", value, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagLessThan(String value) {
            addCriterion("VipCashTag <", value, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagLessThanOrEqualTo(String value) {
            addCriterion("VipCashTag <=", value, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagLike(String value) {
            addCriterion("VipCashTag like", value, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagNotLike(String value) {
            addCriterion("VipCashTag not like", value, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagIn(List<String> values) {
            addCriterion("VipCashTag in", values, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagNotIn(List<String> values) {
            addCriterion("VipCashTag not in", values, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagBetween(String value1, String value2) {
            addCriterion("VipCashTag between", value1, value2, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andVipcashtagNotBetween(String value1, String value2) {
            addCriterion("VipCashTag not between", value1, value2, "vipcashtag");
            return (Criteria) this;
        }

        public Criteria andBalaqtyIsNull() {
            addCriterion("BalaQty is null");
            return (Criteria) this;
        }

        public Criteria andBalaqtyIsNotNull() {
            addCriterion("BalaQty is not null");
            return (Criteria) this;
        }

        public Criteria andBalaqtyEqualTo(BigDecimal value) {
            addCriterion("BalaQty =", value, "balaqty");
            return (Criteria) this;
        }

        public Criteria andBalaqtyNotEqualTo(BigDecimal value) {
            addCriterion("BalaQty <>", value, "balaqty");
            return (Criteria) this;
        }

        public Criteria andBalaqtyGreaterThan(BigDecimal value) {
            addCriterion("BalaQty >", value, "balaqty");
            return (Criteria) this;
        }

        public Criteria andBalaqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaQty >=", value, "balaqty");
            return (Criteria) this;
        }

        public Criteria andBalaqtyLessThan(BigDecimal value) {
            addCriterion("BalaQty <", value, "balaqty");
            return (Criteria) this;
        }

        public Criteria andBalaqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaQty <=", value, "balaqty");
            return (Criteria) this;
        }

        public Criteria andBalaqtyIn(List<BigDecimal> values) {
            addCriterion("BalaQty in", values, "balaqty");
            return (Criteria) this;
        }

        public Criteria andBalaqtyNotIn(List<BigDecimal> values) {
            addCriterion("BalaQty not in", values, "balaqty");
            return (Criteria) this;
        }

        public Criteria andBalaqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaQty between", value1, value2, "balaqty");
            return (Criteria) this;
        }

        public Criteria andBalaqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaQty not between", value1, value2, "balaqty");
            return (Criteria) this;
        }

        public Criteria andBalagqtyIsNull() {
            addCriterion("BalaGQty is null");
            return (Criteria) this;
        }

        public Criteria andBalagqtyIsNotNull() {
            addCriterion("BalaGQty is not null");
            return (Criteria) this;
        }

        public Criteria andBalagqtyEqualTo(BigDecimal value) {
            addCriterion("BalaGQty =", value, "balagqty");
            return (Criteria) this;
        }

        public Criteria andBalagqtyNotEqualTo(BigDecimal value) {
            addCriterion("BalaGQty <>", value, "balagqty");
            return (Criteria) this;
        }

        public Criteria andBalagqtyGreaterThan(BigDecimal value) {
            addCriterion("BalaGQty >", value, "balagqty");
            return (Criteria) this;
        }

        public Criteria andBalagqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaGQty >=", value, "balagqty");
            return (Criteria) this;
        }

        public Criteria andBalagqtyLessThan(BigDecimal value) {
            addCriterion("BalaGQty <", value, "balagqty");
            return (Criteria) this;
        }

        public Criteria andBalagqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BalaGQty <=", value, "balagqty");
            return (Criteria) this;
        }

        public Criteria andBalagqtyIn(List<BigDecimal> values) {
            addCriterion("BalaGQty in", values, "balagqty");
            return (Criteria) this;
        }

        public Criteria andBalagqtyNotIn(List<BigDecimal> values) {
            addCriterion("BalaGQty not in", values, "balagqty");
            return (Criteria) this;
        }

        public Criteria andBalagqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaGQty between", value1, value2, "balagqty");
            return (Criteria) this;
        }

        public Criteria andBalagqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BalaGQty not between", value1, value2, "balagqty");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyIsNull() {
            addCriterion("TBalaqty is null");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyIsNotNull() {
            addCriterion("TBalaqty is not null");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyEqualTo(BigDecimal value) {
            addCriterion("TBalaqty =", value, "tbalaqty");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyNotEqualTo(BigDecimal value) {
            addCriterion("TBalaqty <>", value, "tbalaqty");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyGreaterThan(BigDecimal value) {
            addCriterion("TBalaqty >", value, "tbalaqty");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TBalaqty >=", value, "tbalaqty");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyLessThan(BigDecimal value) {
            addCriterion("TBalaqty <", value, "tbalaqty");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TBalaqty <=", value, "tbalaqty");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyIn(List<BigDecimal> values) {
            addCriterion("TBalaqty in", values, "tbalaqty");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyNotIn(List<BigDecimal> values) {
            addCriterion("TBalaqty not in", values, "tbalaqty");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TBalaqty between", value1, value2, "tbalaqty");
            return (Criteria) this;
        }

        public Criteria andTbalaqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TBalaqty not between", value1, value2, "tbalaqty");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyIsNull() {
            addCriterion("TBalagqty is null");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyIsNotNull() {
            addCriterion("TBalagqty is not null");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyEqualTo(BigDecimal value) {
            addCriterion("TBalagqty =", value, "tbalagqty");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyNotEqualTo(BigDecimal value) {
            addCriterion("TBalagqty <>", value, "tbalagqty");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyGreaterThan(BigDecimal value) {
            addCriterion("TBalagqty >", value, "tbalagqty");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TBalagqty >=", value, "tbalagqty");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyLessThan(BigDecimal value) {
            addCriterion("TBalagqty <", value, "tbalagqty");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TBalagqty <=", value, "tbalagqty");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyIn(List<BigDecimal> values) {
            addCriterion("TBalagqty in", values, "tbalagqty");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyNotIn(List<BigDecimal> values) {
            addCriterion("TBalagqty not in", values, "tbalagqty");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TBalagqty between", value1, value2, "tbalagqty");
            return (Criteria) this;
        }

        public Criteria andTbalagqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TBalagqty not between", value1, value2, "tbalagqty");
            return (Criteria) this;
        }

        public Criteria andBatchfixIsNull() {
            addCriterion("BatchFix is null");
            return (Criteria) this;
        }

        public Criteria andBatchfixIsNotNull() {
            addCriterion("BatchFix is not null");
            return (Criteria) this;
        }

        public Criteria andBatchfixEqualTo(String value) {
            addCriterion("BatchFix =", value, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixNotEqualTo(String value) {
            addCriterion("BatchFix <>", value, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixGreaterThan(String value) {
            addCriterion("BatchFix >", value, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixGreaterThanOrEqualTo(String value) {
            addCriterion("BatchFix >=", value, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixLessThan(String value) {
            addCriterion("BatchFix <", value, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixLessThanOrEqualTo(String value) {
            addCriterion("BatchFix <=", value, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixLike(String value) {
            addCriterion("BatchFix like", value, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixNotLike(String value) {
            addCriterion("BatchFix not like", value, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixIn(List<String> values) {
            addCriterion("BatchFix in", values, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixNotIn(List<String> values) {
            addCriterion("BatchFix not in", values, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixBetween(String value1, String value2) {
            addCriterion("BatchFix between", value1, value2, "batchfix");
            return (Criteria) this;
        }

        public Criteria andBatchfixNotBetween(String value1, String value2) {
            addCriterion("BatchFix not between", value1, value2, "batchfix");
            return (Criteria) this;
        }

        public Criteria andPreassignflagIsNull() {
            addCriterion("PreAssignFlag is null");
            return (Criteria) this;
        }

        public Criteria andPreassignflagIsNotNull() {
            addCriterion("PreAssignFlag is not null");
            return (Criteria) this;
        }

        public Criteria andPreassignflagEqualTo(String value) {
            addCriterion("PreAssignFlag =", value, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagNotEqualTo(String value) {
            addCriterion("PreAssignFlag <>", value, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagGreaterThan(String value) {
            addCriterion("PreAssignFlag >", value, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagGreaterThanOrEqualTo(String value) {
            addCriterion("PreAssignFlag >=", value, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagLessThan(String value) {
            addCriterion("PreAssignFlag <", value, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagLessThanOrEqualTo(String value) {
            addCriterion("PreAssignFlag <=", value, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagLike(String value) {
            addCriterion("PreAssignFlag like", value, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagNotLike(String value) {
            addCriterion("PreAssignFlag not like", value, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagIn(List<String> values) {
            addCriterion("PreAssignFlag in", values, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagNotIn(List<String> values) {
            addCriterion("PreAssignFlag not in", values, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagBetween(String value1, String value2) {
            addCriterion("PreAssignFlag between", value1, value2, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPreassignflagNotBetween(String value1, String value2) {
            addCriterion("PreAssignFlag not between", value1, value2, "preassignflag");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoIsNull() {
            addCriterion("PromGQtyNo is null");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoIsNotNull() {
            addCriterion("PromGQtyNo is not null");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoEqualTo(BigDecimal value) {
            addCriterion("PromGQtyNo =", value, "promgqtyno");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoNotEqualTo(BigDecimal value) {
            addCriterion("PromGQtyNo <>", value, "promgqtyno");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoGreaterThan(BigDecimal value) {
            addCriterion("PromGQtyNo >", value, "promgqtyno");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PromGQtyNo >=", value, "promgqtyno");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoLessThan(BigDecimal value) {
            addCriterion("PromGQtyNo <", value, "promgqtyno");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PromGQtyNo <=", value, "promgqtyno");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoIn(List<BigDecimal> values) {
            addCriterion("PromGQtyNo in", values, "promgqtyno");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoNotIn(List<BigDecimal> values) {
            addCriterion("PromGQtyNo not in", values, "promgqtyno");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromGQtyNo between", value1, value2, "promgqtyno");
            return (Criteria) this;
        }

        public Criteria andPromgqtynoNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromGQtyNo not between", value1, value2, "promgqtyno");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesIsNull() {
            addCriterion("PromGQtyYes is null");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesIsNotNull() {
            addCriterion("PromGQtyYes is not null");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesEqualTo(BigDecimal value) {
            addCriterion("PromGQtyYes =", value, "promgqtyyes");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesNotEqualTo(BigDecimal value) {
            addCriterion("PromGQtyYes <>", value, "promgqtyyes");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesGreaterThan(BigDecimal value) {
            addCriterion("PromGQtyYes >", value, "promgqtyyes");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PromGQtyYes >=", value, "promgqtyyes");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesLessThan(BigDecimal value) {
            addCriterion("PromGQtyYes <", value, "promgqtyyes");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PromGQtyYes <=", value, "promgqtyyes");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesIn(List<BigDecimal> values) {
            addCriterion("PromGQtyYes in", values, "promgqtyyes");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesNotIn(List<BigDecimal> values) {
            addCriterion("PromGQtyYes not in", values, "promgqtyyes");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromGQtyYes between", value1, value2, "promgqtyyes");
            return (Criteria) this;
        }

        public Criteria andPromgqtyyesNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromGQtyYes not between", value1, value2, "promgqtyyes");
            return (Criteria) this;
        }

        public Criteria andPromgamtIsNull() {
            addCriterion("PromGAmt is null");
            return (Criteria) this;
        }

        public Criteria andPromgamtIsNotNull() {
            addCriterion("PromGAmt is not null");
            return (Criteria) this;
        }

        public Criteria andPromgamtEqualTo(BigDecimal value) {
            addCriterion("PromGAmt =", value, "promgamt");
            return (Criteria) this;
        }

        public Criteria andPromgamtNotEqualTo(BigDecimal value) {
            addCriterion("PromGAmt <>", value, "promgamt");
            return (Criteria) this;
        }

        public Criteria andPromgamtGreaterThan(BigDecimal value) {
            addCriterion("PromGAmt >", value, "promgamt");
            return (Criteria) this;
        }

        public Criteria andPromgamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PromGAmt >=", value, "promgamt");
            return (Criteria) this;
        }

        public Criteria andPromgamtLessThan(BigDecimal value) {
            addCriterion("PromGAmt <", value, "promgamt");
            return (Criteria) this;
        }

        public Criteria andPromgamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PromGAmt <=", value, "promgamt");
            return (Criteria) this;
        }

        public Criteria andPromgamtIn(List<BigDecimal> values) {
            addCriterion("PromGAmt in", values, "promgamt");
            return (Criteria) this;
        }

        public Criteria andPromgamtNotIn(List<BigDecimal> values) {
            addCriterion("PromGAmt not in", values, "promgamt");
            return (Criteria) this;
        }

        public Criteria andPromgamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromGAmt between", value1, value2, "promgamt");
            return (Criteria) this;
        }

        public Criteria andPromgamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromGAmt not between", value1, value2, "promgamt");
            return (Criteria) this;
        }

        public Criteria andPaypointsIsNull() {
            addCriterion("PayPoints is null");
            return (Criteria) this;
        }

        public Criteria andPaypointsIsNotNull() {
            addCriterion("PayPoints is not null");
            return (Criteria) this;
        }

        public Criteria andPaypointsEqualTo(BigDecimal value) {
            addCriterion("PayPoints =", value, "paypoints");
            return (Criteria) this;
        }

        public Criteria andPaypointsNotEqualTo(BigDecimal value) {
            addCriterion("PayPoints <>", value, "paypoints");
            return (Criteria) this;
        }

        public Criteria andPaypointsGreaterThan(BigDecimal value) {
            addCriterion("PayPoints >", value, "paypoints");
            return (Criteria) this;
        }

        public Criteria andPaypointsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PayPoints >=", value, "paypoints");
            return (Criteria) this;
        }

        public Criteria andPaypointsLessThan(BigDecimal value) {
            addCriterion("PayPoints <", value, "paypoints");
            return (Criteria) this;
        }

        public Criteria andPaypointsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PayPoints <=", value, "paypoints");
            return (Criteria) this;
        }

        public Criteria andPaypointsIn(List<BigDecimal> values) {
            addCriterion("PayPoints in", values, "paypoints");
            return (Criteria) this;
        }

        public Criteria andPaypointsNotIn(List<BigDecimal> values) {
            addCriterion("PayPoints not in", values, "paypoints");
            return (Criteria) this;
        }

        public Criteria andPaypointsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PayPoints between", value1, value2, "paypoints");
            return (Criteria) this;
        }

        public Criteria andPaypointsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PayPoints not between", value1, value2, "paypoints");
            return (Criteria) this;
        }

        public Criteria andFixedpriceIsNull() {
            addCriterion("FixedPrice is null");
            return (Criteria) this;
        }

        public Criteria andFixedpriceIsNotNull() {
            addCriterion("FixedPrice is not null");
            return (Criteria) this;
        }

        public Criteria andFixedpriceEqualTo(BigDecimal value) {
            addCriterion("FixedPrice =", value, "fixedprice");
            return (Criteria) this;
        }

        public Criteria andFixedpriceNotEqualTo(BigDecimal value) {
            addCriterion("FixedPrice <>", value, "fixedprice");
            return (Criteria) this;
        }

        public Criteria andFixedpriceGreaterThan(BigDecimal value) {
            addCriterion("FixedPrice >", value, "fixedprice");
            return (Criteria) this;
        }

        public Criteria andFixedpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FixedPrice >=", value, "fixedprice");
            return (Criteria) this;
        }

        public Criteria andFixedpriceLessThan(BigDecimal value) {
            addCriterion("FixedPrice <", value, "fixedprice");
            return (Criteria) this;
        }

        public Criteria andFixedpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FixedPrice <=", value, "fixedprice");
            return (Criteria) this;
        }

        public Criteria andFixedpriceIn(List<BigDecimal> values) {
            addCriterion("FixedPrice in", values, "fixedprice");
            return (Criteria) this;
        }

        public Criteria andFixedpriceNotIn(List<BigDecimal> values) {
            addCriterion("FixedPrice not in", values, "fixedprice");
            return (Criteria) this;
        }

        public Criteria andFixedpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FixedPrice between", value1, value2, "fixedprice");
            return (Criteria) this;
        }

        public Criteria andFixedpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FixedPrice not between", value1, value2, "fixedprice");
            return (Criteria) this;
        }

        public Criteria andPriceunitIsNull() {
            addCriterion("PriceUnit is null");
            return (Criteria) this;
        }

        public Criteria andPriceunitIsNotNull() {
            addCriterion("PriceUnit is not null");
            return (Criteria) this;
        }

        public Criteria andPriceunitEqualTo(String value) {
            addCriterion("PriceUnit =", value, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitNotEqualTo(String value) {
            addCriterion("PriceUnit <>", value, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitGreaterThan(String value) {
            addCriterion("PriceUnit >", value, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitGreaterThanOrEqualTo(String value) {
            addCriterion("PriceUnit >=", value, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitLessThan(String value) {
            addCriterion("PriceUnit <", value, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitLessThanOrEqualTo(String value) {
            addCriterion("PriceUnit <=", value, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitLike(String value) {
            addCriterion("PriceUnit like", value, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitNotLike(String value) {
            addCriterion("PriceUnit not like", value, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitIn(List<String> values) {
            addCriterion("PriceUnit in", values, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitNotIn(List<String> values) {
            addCriterion("PriceUnit not in", values, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitBetween(String value1, String value2) {
            addCriterion("PriceUnit between", value1, value2, "priceunit");
            return (Criteria) this;
        }

        public Criteria andPriceunitNotBetween(String value1, String value2) {
            addCriterion("PriceUnit not between", value1, value2, "priceunit");
            return (Criteria) this;
        }

        public Criteria andBonusprepayIsNull() {
            addCriterion("BonusPrepay is null");
            return (Criteria) this;
        }

        public Criteria andBonusprepayIsNotNull() {
            addCriterion("BonusPrepay is not null");
            return (Criteria) this;
        }

        public Criteria andBonusprepayEqualTo(BigDecimal value) {
            addCriterion("BonusPrepay =", value, "bonusprepay");
            return (Criteria) this;
        }

        public Criteria andBonusprepayNotEqualTo(BigDecimal value) {
            addCriterion("BonusPrepay <>", value, "bonusprepay");
            return (Criteria) this;
        }

        public Criteria andBonusprepayGreaterThan(BigDecimal value) {
            addCriterion("BonusPrepay >", value, "bonusprepay");
            return (Criteria) this;
        }

        public Criteria andBonusprepayGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BonusPrepay >=", value, "bonusprepay");
            return (Criteria) this;
        }

        public Criteria andBonusprepayLessThan(BigDecimal value) {
            addCriterion("BonusPrepay <", value, "bonusprepay");
            return (Criteria) this;
        }

        public Criteria andBonusprepayLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BonusPrepay <=", value, "bonusprepay");
            return (Criteria) this;
        }

        public Criteria andBonusprepayIn(List<BigDecimal> values) {
            addCriterion("BonusPrepay in", values, "bonusprepay");
            return (Criteria) this;
        }

        public Criteria andBonusprepayNotIn(List<BigDecimal> values) {
            addCriterion("BonusPrepay not in", values, "bonusprepay");
            return (Criteria) this;
        }

        public Criteria andBonusprepayBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BonusPrepay between", value1, value2, "bonusprepay");
            return (Criteria) this;
        }

        public Criteria andBonusprepayNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BonusPrepay not between", value1, value2, "bonusprepay");
            return (Criteria) this;
        }

        public Criteria andPickamtIsNull() {
            addCriterion("PickAmt is null");
            return (Criteria) this;
        }

        public Criteria andPickamtIsNotNull() {
            addCriterion("PickAmt is not null");
            return (Criteria) this;
        }

        public Criteria andPickamtEqualTo(BigDecimal value) {
            addCriterion("PickAmt =", value, "pickamt");
            return (Criteria) this;
        }

        public Criteria andPickamtNotEqualTo(BigDecimal value) {
            addCriterion("PickAmt <>", value, "pickamt");
            return (Criteria) this;
        }

        public Criteria andPickamtGreaterThan(BigDecimal value) {
            addCriterion("PickAmt >", value, "pickamt");
            return (Criteria) this;
        }

        public Criteria andPickamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PickAmt >=", value, "pickamt");
            return (Criteria) this;
        }

        public Criteria andPickamtLessThan(BigDecimal value) {
            addCriterion("PickAmt <", value, "pickamt");
            return (Criteria) this;
        }

        public Criteria andPickamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PickAmt <=", value, "pickamt");
            return (Criteria) this;
        }

        public Criteria andPickamtIn(List<BigDecimal> values) {
            addCriterion("PickAmt in", values, "pickamt");
            return (Criteria) this;
        }

        public Criteria andPickamtNotIn(List<BigDecimal> values) {
            addCriterion("PickAmt not in", values, "pickamt");
            return (Criteria) this;
        }

        public Criteria andPickamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PickAmt between", value1, value2, "pickamt");
            return (Criteria) this;
        }

        public Criteria andPickamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PickAmt not between", value1, value2, "pickamt");
            return (Criteria) this;
        }

        public Criteria andElecgiftIsNull() {
            addCriterion("ElecGift is null");
            return (Criteria) this;
        }

        public Criteria andElecgiftIsNotNull() {
            addCriterion("ElecGift is not null");
            return (Criteria) this;
        }

        public Criteria andElecgiftEqualTo(BigDecimal value) {
            addCriterion("ElecGift =", value, "elecgift");
            return (Criteria) this;
        }

        public Criteria andElecgiftNotEqualTo(BigDecimal value) {
            addCriterion("ElecGift <>", value, "elecgift");
            return (Criteria) this;
        }

        public Criteria andElecgiftGreaterThan(BigDecimal value) {
            addCriterion("ElecGift >", value, "elecgift");
            return (Criteria) this;
        }

        public Criteria andElecgiftGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ElecGift >=", value, "elecgift");
            return (Criteria) this;
        }

        public Criteria andElecgiftLessThan(BigDecimal value) {
            addCriterion("ElecGift <", value, "elecgift");
            return (Criteria) this;
        }

        public Criteria andElecgiftLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ElecGift <=", value, "elecgift");
            return (Criteria) this;
        }

        public Criteria andElecgiftIn(List<BigDecimal> values) {
            addCriterion("ElecGift in", values, "elecgift");
            return (Criteria) this;
        }

        public Criteria andElecgiftNotIn(List<BigDecimal> values) {
            addCriterion("ElecGift not in", values, "elecgift");
            return (Criteria) this;
        }

        public Criteria andElecgiftBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ElecGift between", value1, value2, "elecgift");
            return (Criteria) this;
        }

        public Criteria andElecgiftNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ElecGift not between", value1, value2, "elecgift");
            return (Criteria) this;
        }

        public Criteria andPhstoreIsNull() {
            addCriterion("PHStore is null");
            return (Criteria) this;
        }

        public Criteria andPhstoreIsNotNull() {
            addCriterion("PHStore is not null");
            return (Criteria) this;
        }

        public Criteria andPhstoreEqualTo(String value) {
            addCriterion("PHStore =", value, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreNotEqualTo(String value) {
            addCriterion("PHStore <>", value, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreGreaterThan(String value) {
            addCriterion("PHStore >", value, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreGreaterThanOrEqualTo(String value) {
            addCriterion("PHStore >=", value, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreLessThan(String value) {
            addCriterion("PHStore <", value, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreLessThanOrEqualTo(String value) {
            addCriterion("PHStore <=", value, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreLike(String value) {
            addCriterion("PHStore like", value, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreNotLike(String value) {
            addCriterion("PHStore not like", value, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreIn(List<String> values) {
            addCriterion("PHStore in", values, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreNotIn(List<String> values) {
            addCriterion("PHStore not in", values, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreBetween(String value1, String value2) {
            addCriterion("PHStore between", value1, value2, "phstore");
            return (Criteria) this;
        }

        public Criteria andPhstoreNotBetween(String value1, String value2) {
            addCriterion("PHStore not between", value1, value2, "phstore");
            return (Criteria) this;
        }

        public Criteria andDisttagIsNull() {
            addCriterion("DistTag is null");
            return (Criteria) this;
        }

        public Criteria andDisttagIsNotNull() {
            addCriterion("DistTag is not null");
            return (Criteria) this;
        }

        public Criteria andDisttagEqualTo(String value) {
            addCriterion("DistTag =", value, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagNotEqualTo(String value) {
            addCriterion("DistTag <>", value, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagGreaterThan(String value) {
            addCriterion("DistTag >", value, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagGreaterThanOrEqualTo(String value) {
            addCriterion("DistTag >=", value, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagLessThan(String value) {
            addCriterion("DistTag <", value, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagLessThanOrEqualTo(String value) {
            addCriterion("DistTag <=", value, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagLike(String value) {
            addCriterion("DistTag like", value, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagNotLike(String value) {
            addCriterion("DistTag not like", value, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagIn(List<String> values) {
            addCriterion("DistTag in", values, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagNotIn(List<String> values) {
            addCriterion("DistTag not in", values, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagBetween(String value1, String value2) {
            addCriterion("DistTag between", value1, value2, "disttag");
            return (Criteria) this;
        }

        public Criteria andDisttagNotBetween(String value1, String value2) {
            addCriterion("DistTag not between", value1, value2, "disttag");
            return (Criteria) this;
        }

        public Criteria andProfitrateIsNull() {
            addCriterion("ProfitRate is null");
            return (Criteria) this;
        }

        public Criteria andProfitrateIsNotNull() {
            addCriterion("ProfitRate is not null");
            return (Criteria) this;
        }

        public Criteria andProfitrateEqualTo(BigDecimal value) {
            addCriterion("ProfitRate =", value, "profitrate");
            return (Criteria) this;
        }

        public Criteria andProfitrateNotEqualTo(BigDecimal value) {
            addCriterion("ProfitRate <>", value, "profitrate");
            return (Criteria) this;
        }

        public Criteria andProfitrateGreaterThan(BigDecimal value) {
            addCriterion("ProfitRate >", value, "profitrate");
            return (Criteria) this;
        }

        public Criteria andProfitrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ProfitRate >=", value, "profitrate");
            return (Criteria) this;
        }

        public Criteria andProfitrateLessThan(BigDecimal value) {
            addCriterion("ProfitRate <", value, "profitrate");
            return (Criteria) this;
        }

        public Criteria andProfitrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ProfitRate <=", value, "profitrate");
            return (Criteria) this;
        }

        public Criteria andProfitrateIn(List<BigDecimal> values) {
            addCriterion("ProfitRate in", values, "profitrate");
            return (Criteria) this;
        }

        public Criteria andProfitrateNotIn(List<BigDecimal> values) {
            addCriterion("ProfitRate not in", values, "profitrate");
            return (Criteria) this;
        }

        public Criteria andProfitrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ProfitRate between", value1, value2, "profitrate");
            return (Criteria) this;
        }

        public Criteria andProfitrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ProfitRate not between", value1, value2, "profitrate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}